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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Week starts on Monday, not Sunday

Status
Not open for further replies.

Rob892

Programmer
May 24, 2003
10
US
I know I have seen posts about this before, but I cannot seem to find them. My problem is that I have a report that reports data on a weekly and monthly basis, but our workweek starts on monday, and ends on sunday. Is there a simple way to get the report to format this way?
 
The DatePart() function allows you to specify the first day of the week.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top