Date Grouping

[edojan]

Hi

I have this table

date, error code, user

i need the output to be :
User, Error Code, Month/Week1 Count of error code, Month/Week2 Count of error code .....

basically how do i make error code field as count with each week 1-4 for the month?

Format([AuditDate],"mm-ww") create week but in 1-52 weeks not 1-4 for the month. Also need something like ' count if week = 1'

Hope this makes sense.

Thanks

 

[EMP]

Week numbers ww in the Format() function apply to the year and not to the months in a year.

Besides, most of the time, there are 4 weeks and 2 or 3 days in a month. You will have a hard time trying to number the weeks in a month as 1-4.

^