query

  • Thread starter Thread starter J_ B
  • Start date Start date
J

J_ B

If i have 2 tables with 1 PK (say SERIAL). How do i do a query in access
that shows all SERIALs in table1 that do not exist in table2.

ie
table1.SERIAL data: 1,2,3,4,5
table2.SERIAL data: 1,2,3

I expect to get 2 rows from the query with serials 4 and 5.

thanx
 
As a new person to Access, I have a quick question, would I select the * to
grab the whole table or select each field individualy?

Thanks,

Jonathan
Russell Lucas said:
open a new query in design view. Then add the table you wish to output
Click to expand...
from. Double click the appriopriate field to add it to the query. Right
click in the criteria box and select build. Click the buttom labeled not and
then find the table you wish to compair to from the table folder (lower left
window) and select the matching field. Click ok and you have yourself a
working comparison query.
 
Back
Top