My query doesn't display all data - records from tables! HELP

[Ivan]

Here is problem:

I have table with buyers, they are buying in two separate shoops, and are
paying it trough compezation- to me. So I have two diferent tables, forms
where I record their expenses and one table with their id, names..., one
table with articles, and two tables for two different stores. I need to
calculate how much they have spent in both stores, and the query need to have
these fields: Buyer name, articles, sum of amount in first store and amount
in second store, and total of first and second store.
I have tried to do this, but the query displays only those buyers who have
bought goods in both stores, not in single stores, so I can't see all buyers,
and that's a big problem for me.

Please, please help

Thanks in advance,
p.s. my English is bad, SORRY

 

[John Spencer]

Your problem seems to be that you have a table for each store. You
should have one table for both stores with a field in the table to
indicate which store is involved in the transaction.

You could use a UNION query to get the data for both stores and then use
the union query to generate the needed information.

I don't understand your structure enough to give you specific advice.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================