Combining daily counts into a monthly total (1 Viewer)

[i@bluefocus]

I am new to Access and have been trying to figure out how to group daily counts into one total number for a given month. Currently, I only know how to make adjustments within the "Design View" of my queries. Is there something in the "Criteria" field that I can enter (instead of Between #7/1/2009# and #7/31/2009#) to get the sum of all hits in the month of July?

Thanks for your help...
i

 

[DJkarl]

In design view hit the Totals button (the greek sigma sybol Σ)
This will add a Total row to your query design view, select the column you want to total then change the value from Group By to Sum.

 

[i@bluefocus]

Thanks DJKarl....I did try that but it returned some really big numbers that don't check out with the actual numbers. Let me try it again and recheck that data on the tables i'm querying.

 

[i@bluefocus]

Hey again...no luck. I keep getting numbers in the millions and billions when i use the Sum function. Basically i'm tracking how many times different pages were viewed on our touch-screen city guide. so each "hit" is it's own ID number, along with the source of the hit, time and date of the hit. i'm starting to wonder if there's possibly something wrong with the way the information is imported.

Argh!

 

[gemma-the-husky]

if each hit is recorded separately, try COUNT, rather than SUM, in the expression/function row.

 

[i@bluefocus]

Thanks...I finally figured it out. I ended up creating creating a crosstab query then doing an autocalc: sum. Worked like a charm! Geesh....was that a brain fart...