Group By Question?

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hi,

I have a query that is run by entering a date range and has all the clients
transactions during that period. The query lists each client transaction by
date.

I would like to sum the total of the clients transactions over that period.

Is a Group By the right way to go to get this?

Thanks

George
 
Hi,

I have a query that is run by entering a date range and has all the clients
transactions during that period. The query lists each client transaction by
date.

I would like to sum the total of the clients transactions over that period.

Is a Group By the right way to go to get this?

Thanks

George
Click to expand...

Depends. Do you want to group by the client?

Guessing that you do, create a Totals query based on the table. Use the "Group
By" totals option on the client ID; the "Where" option on the date field, and
criteria to select the desired records; and the "Sum" option on the field you
want to total.
 
Back
Top