Week Numbers

[Chris Watson]

Hi
Im trying to to show a week number on my form, each record will show day date and week number, ie: Mon,Tue,Wed,Thur,Fri,Sat, and Sun will show week 1 and the next 7 days show week 2 and so forth, but to a maximum of 17 weeks or 26 weeks which ever I choose. Is this possible.
Chris

 

[llkhoutx]

Just calculate it

Make sure you have a date without a time component (Cdate).
Build 12/31 of the previous year.
Then subtract Cdate(12/31 of the previous year) from the current date.
Then compute computer mod 7 + 1 of the result.

 

[Chris Watson]

Sounds good but im new to Access and still learning. Can you explain please???

 

[Dreamweaver]

Use The Format()

=Format([ChartDate],"ww",1)

The last option being the First day of the week Read the help Files for more info on the format function

 

[llkhoutx]

Good post Dreamweaver.