week of the month

  • Thread starter Thread starter Guest
  • Start date Start date
G

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