Sheila.deJesus
She
- Local time
- Tomorrow, 00:08
- Joined
- Jul 12, 2006
- Messages
- 70
Good day!
I'm planning to create a form that would show total number of sales transaction per week: If today's month is February, i would like users to see records like this: (Week should start on a Monday and ends on Saturday)
GroupNo______Week1_____Week2_____Week3____Week4____Week5___MTD
GroupA________12_________2__________10________11_______15_____50
GroupB_________8_________5___________7_________1_______21_____42
I can't find a sample code for this particular date criteria. :-(
Thanks in advance!
Sheila
I'm planning to create a form that would show total number of sales transaction per week: If today's month is February, i would like users to see records like this: (Week should start on a Monday and ends on Saturday)
GroupNo______Week1_____Week2_____Week3____Week4____Week5___MTD
GroupA________12_________2__________10________11_______15_____50
GroupB_________8_________5___________7_________1_______21_____42
I can't find a sample code for this particular date criteria. :-(
Thanks in advance!
Sheila