Query sum not adding properly ??

[sneapdogg]

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.

 

[DCrake]

Create an extra column in your query

Mnth:Month([Yourfield])

And group by this new column.

 

[sneapdogg]

Thanks, sorted it.

 

[boblarson]

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.

 

[sneapdogg]

Good point Bob wouldnt have realised that till jan's reports.

Thanks guys, problem solved!