R
Richard Krupa
Hey guys,
Im trying to do a report that will tell me the total for Monday Tuesday
etc... depending on a date range.
If i put the date range 01/07/2002 - 31/07/2002 how can i group each date
into Monday Tuesday Wednesday etc...? Atm the query result just has the date
field and the Extension amount. The Extension amount is Summed to but how
can i group the date so its grouped as Monday Tuesday Wedensday.
Example:
Date Sales
01/07/2003 $100
08/07/2003 $200
15/07/2003 $300
22/07/2003 $400
29/07/2003 $500
(Mon Dates)
Date Sales
02/07/2003 $200
09/07/2003 $400
16/07/2003 $600
23/07/2003 $800
30/07/2003 $1000
(Tues Dates)
Date Sales
03/07/2003 $400
10/07/2003 $800
17/07/2003 $1200
24/07/2003 $1600
31/07/2003 $2000
(Wed Dates)
Result:
Mon = $1,500
Tues = $3,000
Wed = $6,000
What the report is trying to do break the month into days so they can see
what day of the week is the busiest.
Hope you guys understand what i'm trying to do
Im trying to do a report that will tell me the total for Monday Tuesday
etc... depending on a date range.
If i put the date range 01/07/2002 - 31/07/2002 how can i group each date
into Monday Tuesday Wednesday etc...? Atm the query result just has the date
field and the Extension amount. The Extension amount is Summed to but how
can i group the date so its grouped as Monday Tuesday Wedensday.
Example:
Date Sales
01/07/2003 $100
08/07/2003 $200
15/07/2003 $300
22/07/2003 $400
29/07/2003 $500
(Mon Dates)
Date Sales
02/07/2003 $200
09/07/2003 $400
16/07/2003 $600
23/07/2003 $800
30/07/2003 $1000
(Tues Dates)
Date Sales
03/07/2003 $400
10/07/2003 $800
17/07/2003 $1200
24/07/2003 $1600
31/07/2003 $2000
(Wed Dates)
Result:
Mon = $1,500
Tues = $3,000
Wed = $6,000
What the report is trying to do break the month into days so they can see
what day of the week is the busiest.
Hope you guys understand what i'm trying to do