Help with DSUM i think

[Derrick_0690]

Good afternoon everyone.

I am having some trouble with a query that I am trying to build. It is probably an easy problem to fix, so please don't laugh at me. I just can't figure it out for some reason.

I have a totals query (Cumulative Totals Query) that is designed to sum up the values in each field of my table (Daily Figures).

No problem there. That works fine.

But now I need to run a query (Rolling Cumulative Totals Query) that will allow me to enter a specific date range. I want only the data within that date range to be summed up.

I built up a query, however it wont sum anything up. It just lists it all.

Example of what it is doing:

DMS ID Redact
Cu0002 31
Cu0002 31

Example of what I need it to do:

Date Range: [Start Date]
[End Date]

DMS ID Redact
Cu0002 62

Can anyone help me out? Not sure if it is the DSum function that I need to use or not. I am a beginner at access so I dont know how to do any programming. I know how to use wizards and the expression builder, but thats about it.

Regards,
Derrick

 

[plog]

It sounds like you brought a date field into your query and used GROUP BY instead of WHERE. If you still need help post the SQL of your query.

 

[Derrick_0690]

Plog,

Absolultely right. Went and made that change and everything worked out.

Thank you very much!

Regards
Derrick_0690