Help with Query non-filtering

[drthdilly]

Still rather new to Access and would appreciate any help. Basically, I created a table with roughly 1600 part numbers and I am matching it up to a database of 8000 part numbers by using a query. I am trying to create a query where I am able to classify the status as complete. However, I am only getting the filtered “complete” reducing the table list to 890 part numbers. However, I want to see the blanks too. If I’m not clear enough, I want to see all 1600 part numbers and the extra column with the comment “complete.” I do not want it filtered. I tried placing a criteria “is null” but turns out the database has no null field, only shows complete parts. Let me know if possible!



I know I could do a Vlookup if I extract the files, but I want to see if I can do it through the database – just trying to get familiarized more with this tool.

[John_G]

If you want to see all 1600 records in your table, you don't need any criteria at all. Am I missing something here?

[clindner.iv]

I think i understand.

When you create the query you are linking the two tables. and rather than see all 8000 records you are only seeing the 1600 reocrds and not the one that do not have a match.

If that is correct, change the link direction so that the table with the 8000 records is the master table. to do this double like on the connecting line in the query between the two tables. you'll see three radio buttons select the radio buttion that says, "include all all records from: the table that has the 8000 records. and only those records from the: table with the 1600 records where the join fields are equal" run your query and see if that works.