Query sum not adding properly ??

sneapdogg

Registered User.
Local time
Today, 04:57
Joined
Aug 25, 2010
Messages
11
I have a query to add total user DOS requests up for the month.
Each record added is datestamped.
My count and sum query adds user totals but is adding totals for each day rather than the whole month so users are showing up several times.

Any idea how to stop it doing this?

I have the timestamp field in query set with "Between [Start Date?] And [End Date?]" criteria as we sometimes need half month totals.
 
Create an extra column in your query

Mnth:Month([Yourfield])

And group by this new column.
 
Thanks, sorted it.
 
Create an extra column in your query

Mnth:Month([Yourfield])

And group by this new column.

You might want to include the YEAR as a separate column and then group by that as well. Otherwise when you get to next year this year's data will be included in the monthly totals.
 
Good point Bob wouldnt have realised that till jan's reports.

Thanks guys, problem solved! :)
 

Users who are viewing this thread

Back
Top Bottom