Select Records

[sturner333]

I am trying to pick certain recards from one table based on data from another
record.
Table1 has a column of used idNumbers.
Table2 has a column of ALL idNumbers.
I would like to make a QUERY to list all the non-used idNumbers.
Thanks for the help

 

[Dennis]

Put Table2 and then Table1 in the query design grid. Create a join on the ID
numbers and make the join show all records from table 2 and only those from
table 1 where the joined fields are equal. Select the ID number from table2
into your query and set the criteria for it to Is Null

 

[KARL DEWEY]

Select the ID number from table2 into your query and set the criteria for
it to Is Null

Select the ID number from table2 into your query, Select the ID number from
table1 into your query and set the criteria for it to Is Null.

 

[sturner333]

Thanks, that worked

it to Is Null

Select the ID number from table2 into your query, Select the ID number from
table1 into your query and set the criteria for it to Is Null.

 

[John the ScrubMaster]

S Turner,

I would very much appreciate a sample of your code that worked for you!

Thank you in advance!

Also please mention which types of server(s) the files are on.

-John d

 

[sturner333]

I did it just the way Karl Dewey described. Here is the SQL code:

SELECT DISTINCT tblPlatformCategories.PlatformID, tblBDP.BDPidShort
FROM tblPlatformCategories LEFT JOIN tblBDP ON
tblPlatformCategories.PlatformID = tblBDP.BDPidShort
WHERE (((tblBDP.BDPidShort) Is Null));