week of the month

[Guest]

hi,

iam preparing a crosstab query with the column heading being the weekday
i.e. sunday to saturday and the row heading being the first week to the last
week of the month and the value being the sales met on these dates. please
advice me how to group data as per week of the month

 

[Guest]

Hi binnie,

You can get the week number from beginning of the year easily enough by
using DatePart("ww",CDate(YourDate))
If you really want to find the week in a month, then you have do some more
work.

Hope this helps.