Query Issue

[jersey417]

Hello all,
First time poster long time reader. I’m running into a problem on writing a query that I need some additional help completing. Below is an example of a form I’m trying to run a query off. However, if the inventory level is zero it will not be listed on the form(I can not edit the form). I need all the part numbers, including those with zero inventory, to be represented in my queries.


Part number ----- Inventory
1234 -------------100
ABCD ------------546
9876 -------------32



Example – If I try to query part number BBBB from the example form above currently it will not be represented since it has zero inventory. I’m looking to have the return results look like

Part---------------Inventory
BBBB -------------0


What would be the best way to have all part numbers and their respected inventories represented in my queries?

 

[jersey417]

Sorry, misused the term form/table. Corrected below

----------

Hello all,
First time poster long time reader. I’m running into a problem on writing a query that I need some additional help completing. Below is an example of a table I’m trying to run a query off. However, if the inventory level is zero it will not be listed on the table(I can not edit the form). I need all the part numbers, including those with zero inventory, to be represented in my queries.


Part number ----- Inventory
1234 -------------100
ABCD ------------546
9876 -------------32



Example – If I try to query part number BBBB from the example table above currently it will not be represented since it has zero inventory. I’m looking to have the return results look like

Part---------------Inventory
BBBB -------------0


What would be the best way to have all part numbers and their respected inventories represented in my queries?[/QUOTE]

 

[RichardMGreen]

Your best bet is to make a master table with all the part numbers on it.
You can still have the inventory table in it's current format.

Your query will then look something like this:-

SELECT
     tbl_Parts_Master.Part_Code,tbl_Inventory_Volume
FROM
     tbl_Parts_Master left join tbl_Inventory on tbl_Parts_Master.Part_Code=tbl_Inventory_Volume.Part_Code

The syntax of the above might be a bit adrift but should get you started.