Problem testing two tables in MS-ACCESS 2000

[Swathi37]

Hi All,

I have a question. I have 2 tables say A and B. Table A has account numbers which has data imported from different sources. Table B also has account numbers. Table B has data from a single source. Both tables have a common field CUSTOMER_ID. The question is how do I check whether table A has all account numbers from Table B. I am using MS-ACCESS 2000. Please help me out. Your help is greatly appreciated.
Thanks

 

[randysmid]

Hi,
You can use the Find Unmatched Query Wizard, when you click on Queries, then select New. HTH,
Randy Smith
California Teachers Association

 

[Swathi37]

Thank you Randy for your response.