Caculations in Queries or Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Db where the end product is a report that portays customers that
paid, how much they paid to each event (bible study, sunday school, etc.),
and total paid for that day. No problem. The problem I'm having is
providing a year-end-statement of total monies paid for each individual by
each event.

I have query that asks for the individual's name, but the formula returns a
total of values for every record in the Db rather than just that one person.

I have tried the Total Dollar: Sum([item]+[item1]+{item3]) in both a Query
and Report, but with no success.
 
I would suggest that you use the wizard to buil a totals query by customer by
event.
Maybe you will need to build the first totals query, an update query and
then again run a new totals query and update the table again. Continue to
loop until
you have reached the totals you are looking for by customer by product.

"PaulE" skrev:
 
Back
Top