Help needed with Date format on reports Access 2000

M

Michael Hernon

Hi All,

I am not well versed in programming but I need some help.
I dont know if there is a FAQ part to the newsgroup that covers this
I have reports for my business that print out weekly figures.


I have 2 problems.
1. The weeks all start on a Monday, and my business runs from Sunday to
Saturday.
is there an easy way to change the reports to get Suday as the first
day?

2. Week 1 of my business year is actually 30/11/03 (sunday), but access has
week 1 as 05/01/04(monday)

I have the field that produces the week number as
=Format$([Date],"ww",0,0)
if I change it to =Format$([Date]+32,"ww",0,0) this gets the week numbers
almost right but not quite.

Any help would be great.

Thanks,

Mick.
 
Top