Counting Weeks in MS Access

[ross182]

Does anyone know how to tell Access how to simply count the weeks in the year to date and display it? I need a count of the weeks in the year to date to average out some figures. What is the code to do this?

[CaptainD]

Use the "Datediff" function. It returns a number depending on the interval you choose based off two dates and / or times.
I put this in a command_click event.

Private Sub Command0_Click()
Dim iNumWeeks As Integer
iNumWeeks = DateDiff("ww", "1/1/2006", Date)
MsgBox iNumWeeks
End Sub
 

[ross182]

Well thats helpful but I just want the number of weeks to show up on a report. What do put for code and where in the report design view?

[CaptainD]

Then you need to be more specific with your questions.

Does anyone know how to tell Access how to simply count the weeks in the year to date and display it? I need a count of the weeks in the year to date to average out some figures. What is the code to do this?

Well thats helpful but I just want the number of weeks to show up on a report. What do put for code and where in the report design view?

Where you put it depends on where you want it.

If it's in the detail section and part of each "line" of the report data then pull it in with the query that the report is based on.
(Datediff works in queries in MS Access: "SELECT [LastName], [TotalHours], DATEDIFF("ww", [Date1], [Date2]) AS NumberOfWeeks FROM YourTable")

If it's in a summary field, then we'll need to know what data field it will calculate on and the data that is in it. Example if each "line" in the detail section has a number of weeks as 1, 3, 4 etc. then you would just "=sum([detailfield])"

[palithawarnasiri]

Dear Experts

I need to count number of weeks to the currant date in the month. I am working according to the Arabic calendar which Saturday is the week first day and Friday is last day.

Example: if today date is 31 july 2007 then week number should be 5

I need this as I have to make a auto number.
I am working on Access 2003

Thanks