Group By Question?

[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

 

[John W. Vinson]

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

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.