O
OTWarrior via AccessMonster.com
how do i have a query that displays information via the totals of each week
than each day (i am thinking that i would have to have multiple "step"
queries to acheive this)
eg:
qry1 (daily)
01/01/07 - data1 - count (1)
01/01/07 - data2 - count (1)
02/01/07 - data3 - count (1)
02/01/07 - data4 - count (1)
06/01/07 - data5 - count (1)
07/01/07 - data6 - count (1)
08/01/07 - data7 - count (1)
09/01/07 - data8 - count (1)
09/01/07 - data9 - count (1)
20/01/07 - data10 - count (1)
qry2 (weekly)
01/01/07 until 06/01/07 - count (5)
07/01/07 until 13/01/07 - count (4)
14/01/07 until 20/01/07 - count (1)
hope my question is clear, and thanks in advance for any help you can give.
than each day (i am thinking that i would have to have multiple "step"
queries to acheive this)
eg:
qry1 (daily)
01/01/07 - data1 - count (1)
01/01/07 - data2 - count (1)
02/01/07 - data3 - count (1)
02/01/07 - data4 - count (1)
06/01/07 - data5 - count (1)
07/01/07 - data6 - count (1)
08/01/07 - data7 - count (1)
09/01/07 - data8 - count (1)
09/01/07 - data9 - count (1)
20/01/07 - data10 - count (1)
qry2 (weekly)
01/01/07 until 06/01/07 - count (5)
07/01/07 until 13/01/07 - count (4)
14/01/07 until 20/01/07 - count (1)
hope my question is clear, and thanks in advance for any help you can give.