query

[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

 

[Jonathan Jesse]

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

open a new query in design view. Then add the table you wish to output

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.