beginner - calculate totals per day

[evel79]

hello - is there a way in Access that i can query a table where it
totals the sum of values for each day? for example:

1/1/2003 - 2
10/2/2003 - 3
7/3/2003 - 4
10/2/2003 - 5
1/1/2003 - 6

then i would like this result from the query:

1/1/2003 - 8
10/2/2003 - 8
7/3/2003 - 4

Any suggestions are welcome. Thanks.

 

[Michel Walsh]

Hi,


A Total query should do. Click on the summation button, on the toolbar,
the one that looks like a capital M rotated by 90 degree, and a new line,
total, appear in the grid. Drag the date field in the grid, keep the
proposed GroupBy. Drag the amount field in the grid, change the Group By to
SUM. That's all.


Hoping it may help,
Vanderghast, Access MVP