How to Query that will accumulate totals for each day of the Month (1 Viewer)

[Gezza]

Hi,
I need to write a query that will give me an accumulative total for each day of the month. Can this be done? I know it can be done in MSExcel so I assume it can be in Access, but I don't know how.

Gezza

 

[John Big Booty]

Have a look at the Group BY or Totals query. Put you query into design view and click the Sigma (Σ) button in the tool bar. You will notice that a new row appears in the design view (Total:), this will allow you to do various functions in your query such as Group BY, Sum, Count etc.

You would want to Group By month and Sum whichever field it is you want the total of.

 

[Gezza]

You would want to Group By month and Sum whichever field it is you want the total of.[/quote]

Thanks for your reply,

Yes that gives me a total for the month, but what I am trying to do is have a running total for the month. eg
day One has 100, total as at day One = 100
day Two has 50 total as at day Two = 150
day Three has 150 total as at day Three = 300, and so on

Hope you can help

 

[John Big Booty]

Perhaps this link or even this one will give you some pointers.

 

[Gezza]

Thank you,
I have had a play with DSum and have got it working fine

Gezza