I need help. I have two tables with both containing a cust number which is defined as a primary key.
Every day I load this large file into Access and I want to see if any cust numbers have been updated from the previous day. I can get my other fields to work using <>.
This cust number filed will not work.
help

I think that what you are trying to do is to find out if any new customers have been added or if any old customers have been deleted. You would need two "unmatched" queries to determine this. Make the first one with the "new" table as the first table you select with the wizard and the "old" table as the second. This will tell you which records have been added. Create the same query with the two tables reversed, select the "old" table first, the "new" one second, to find any deleted records.

Thisis not working. I tried that with a new table and an old. The new had two new product numbers, but the query comes out blank. I tried this same query on my product description and it worked.
For some reason, it does not work on the primary key.

Did you use the wizard to build the "unmatched" query? Did you select the correct key field from each table? If so, check your data carefully. If you are still not getting the correct results, post the query.

I think I figured it out.

Thanks!!!!!!!!!