Assuming you have two tables Named "TableA" and "TableB"
TableA TableAId (PK)
TableB TableBId (PK)
TableAId (FK of TAbleA)
How is is possible to write a query that returns the "TableAid" which are not found in TableB
Using Is Not Equal To in a query
Competent Performer
Windows 7 32bit 
Access 2007
Assuming you have two tables Named "TableA" and "TableB"
TableA TableAId (PK)
TableB TableBId (PK)
TableAId (FK of TAbleA)
How is is possible to write a query that returns the "TableAid" which are not found in TableB
Access Developer
Windows XP Access 2003
You can get the wizzard to create this query for you.
Select New
Select "Find Unmatched Query Wizard"
Then respond to the prompts.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Competent Performer
Windows 7 32bit Access 2007
Thanks I got it.
Posting Permissions
Reply With Quote