DATEPART FUNCTION

[Tom Ellison]

Dear Abul:

I'm thinking what you want may be:

WEEK: (Day([somedate]) - 1) \ 7+1

This assumes you are wanting to convert some date in your table or
query into a week number, where dates 1-7 are week 1, 8 - 14 are week
2, etc.

Note that the division is a back-slash for integer division, dropping
the remainder.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Abul Hasan]

Hello everyone,

I want to extract weekly report from access dataabse into recordset.
Scenario is as follows

WEEK Number of SMS
1 50
2 25
3 30

obviously Weeks should be reset when month changes.

Its urgent plz help