Calculated value for week of the year.

How would I write a calculated value so that access would figure the week of the year based on another value like 'Sale Date'?
CindyDDAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
One way:

=Format([Sale Date],"ww")

mx
0
 
CindyDDAuthor Commented:
That worked perfectly. Thanks.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You are welcome ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.