I am trying to set up a report that summarizes data by week. I want to be prompted for the day the week ends on (so I can use it if the week ends on Sunday, or some other day selected). Does anyone have an idea on how to do this? It seems like Access defaults to Sunday through Saturday, but I want to change this at report time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Group by Week - with different week ending day of week
- Thread starter BadDog
- Start date
Hi
In the Acecss Function one of the paramter is the WeekEnding day, just make it a variable you prompt for at run tile instead of using the build in Acecss functions vbMonday etc. After all the weekending does HAVE to be in the range Sunday thru Saturday, the question is which one
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
In the Acecss Function one of the paramter is the WeekEnding day, just make it a variable you prompt for at run tile instead of using the build in Acecss functions vbMonday etc. After all the weekending does HAVE to be in the range Sunday thru Saturday, the question is which one
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now - UK
- Status
Similar threads
- Locked
- Question
- Locked
- Question