Query to Compare 3 tables (1 Viewer)

[B&R]

I would like to create a query that compares 3 different inventory counts of our warehouse. I have created 3 separate tables and have put the serial numbers counted in each table. I would like to have 3 columns, each representing one tables data. The like serial numbers would line up across each column. If all 3 tables had the same serial, all 3 columns would have the serial number listed across the line. If only 2 tables had the same serial number, 2 columns would show the serial number and the third would be blank.

As you can probably tell, I am a newbie. I have attached a 2002 database with some simple tables. Any help would be appreciated !!

Thanks,
B&R

 

[Pat Hartman]

Union the three recordsets. Then create a crosstab based on the union.