DATEPART FUNCTION

  • Thread starter Thread starter Tom Ellison
  • Start date Start date
T

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
 
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
 
Back
Top