beginner - calculate totals per day

  • Thread starter Thread starter evel79
  • Start date Start date
E

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.
 
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
 
Back
Top