How do I retrieve from database list of names that are not displa.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of Freshmen Student and list of Fr Students that purchase
computer. I created a query and I can see how many Fr student purchaste the
compuer. I need to find out how do I retrieve (create query) to find out the
rest of the studnets, that did not purchase.
 
Jola said:
I have a list of Freshmen Student and list of Fr Students that purchase
computer. I created a query and I can see how many Fr student purchaste the
compuer. I need to find out how do I retrieve (create query) to find out the
rest of the studnets, that did not purchase.
Click to expand...


SELECT [Freshmen Student].namefield
FROM [Freshmen Student] LEFT JOIN [Fr Student]
ON [Freshmen Student].ID = [Fr Student].ID
WHERE [Fr Student].ID Is Null
 
I have a list of Freshmen Student and list of Fr Students that purchase
computer. I created a query and I can see how many Fr student purchaste the
compuer. I need to find out how do I retrieve (create query) to find out the
rest of the studnets, that did not purchase.
Click to expand...

Create a new Query, and use the "Unmatched Query" wizard.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top