week overview

[FSCHAMP]

Hello,



I am very new on this forum , I have some knowledge of Access and a little bit of VBA . Now I want to make a weekly overview in form and it must be by weeknumber. So, is there a function in Access or VBA, which I can use for it?
All the data is in a table by date.

Grts,

Gino V.

[jzwp11]

Welcome to the forum!

You can use the datepart() function with the interval set to "ww" to get the week number. Check out Access' help section for more on the function. Her is the general syntax of the function

DatePart(interval, date[,firstdayofweek[, firstweekofyear]])

[FSCHAMP]

Thanks a lot,

But I had found it in the meantime on this forum, So you can close this item.

Grts,

Gino V.

[jzwp11]

I'm glad you were able to find a solution. Unfortunately, I think only the original person who made the post can close it.