sum data BY DAY!?

[nescartel]

hello gurus... pliz help me...

i have datas that will be updated HOURLY, example:

===TIME=== ===DATA===
Jan 1, 2005 1.00pm 1000
Jan 1, 2005 2.00pm 2000
Jan 1, 2005 3.00pm 3000
Feb 3, 2005 6.00am 1457
Feb 4, 2005 5.00pm 8798

what i want to do is sum data according to DAY, so that;

===TIME=== ===DATA===
Jan 1, 2005 6000
Feb 3, 2005 1457
Feb 4, 2005 8798

hmmm... how can i achieve this? any ideas? i'm quite new here so pliz be gentle

 

[maxmangion]

create a total query, group by day and sum your field in question. In order to create a total query, when you are in the query design view, click on the Σ symbol, in order to get the totals row ... then select the "group by" and "sum" accordingly.

 

[nescartel]

i've managed to get the "total" field. every field has "group by" as default, but there is no selection as to "group by day". where can i find it? also, the sum selection does not return a total of values! am i doing it wrong? can u please point out where i've done wrong?

 

[maxmangion]

just leave the group by to you day field, and choose sum in the other field where you have the data you want to sum.

 

[nescartel]

thanx a lot maxmangion! that was so obvious! hehehe this forum ROCKS!!!

 

[maxmangion]

you're welcome ... i'm glad you've managed to sort it out