Number of week in the month

[kft10 via AccessMonster.com]

Hi All,

Is anyobdy can tell me how to get the number of week in the month in Access?
For example:
- Today (8/1/08) is 1st week,
- 8/27/08 is 5th week.
etc.


Thank you in advance.

Rgds,
KF

 

[Lynn Trapp]

Hi All,

Is anyobdy can tell me how to get the number of week in the month in Access?
For example:
- Today (8/1/08) is 1st week,
- 8/27/08 is 5th week.
etc.


Thank you in advance.

Rgds,
KF

Answered in another newsgroup
Lynn Trapp
www.ltcomputerdesigns.com