Recent content by 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...

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...

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 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...