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 - 20 Apr 2008 14:40 GMT
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
'====================================================
> Here is problem:
>
[quoted text clipped - 13 lines]
> Thanks in advance,
> p.s. my English is bad, SORRY