sometimes you forget the basics!

I linked up two tables in a query by PO#. Lets say table 1 has 3 occurances of a PO# and table 2 only has one occurance. In the resulting linked query the PO# will show up 3 times, how can I serparate the results on the query so that I'll know that table 1 has 3 occurances and that table 2 only has one.

If it means anything, the other rows in the query show the dollar amount for each table.



Thanks for any help!!!

Edited by: motorola1 on Thu Jun 2 10:59:57 EDT 2005.