How does Access group weeks?

[danikuper]

Simple question:

When using a report to group my data by week, how does Access calculates the weeks (1, 2, 3, 4, 5..)?

thanks in advance!

 

[raskew]

Eeh, maybe...

Pat, we weren't told what functions were employed so there may be wiggle-room here.

Look at the (97) help file on the DatePart() function. The week in which 1 Jan occurs is indeed the default, but there are other options.

Bob

 

[danikuper]

Hummm... what about when you ask Access to group weeks by month? like:

Jannuary week1
Jannuary week2
Jannuary week3
Jannuary week4
Jannuary week5
February week1
February week2
etc..

How are those weeks grouped? Like, will Jan 2003 week 1 be from day 1 till day 7 or will it consider Mon through Sunday?

dk