Date grouping by week

[Brian K. Sheperd]

I have a text file with dates, employee number, and hours. I imported the
file into a database table. With the report wizard, my first grouping was
by employee number, and the second was by date. I wanted to group the date
by weeks; however they want the range to be from Mon to Sun. The access
grouping is from Sun to Sat. Is there a way to change this?

Thanks,
Brian

 

[fredg]

I have a text file with dates, employee number, and hours. I imported the
file into a database table. With the report wizard, my first grouping was
by employee number, and the second was by date. I wanted to group the date
by weeks; however they want the range to be from Mon to Sun. The access
grouping is from Sun to Sat. Is there a way to change this?

Thanks,
Brian

You can use the DatePart() function.
it has an argument to set the first day of the week to whatever day
you want.
In code:
MyWeek =DatePart("ww",[DateField],vbMonday)

In the control source of an unbound control:
=DatePart("ww",[DateField],2)

See VBA help.

 

[Brian K. Sheperd]

Thank you.

I added that code to a query, and then I was able to group my report.
Worked great.

Thanks again,
Brian

I have a text file with dates, employee number, and hours. I imported the
file into a database table. With the report wizard, my first grouping was
by employee number, and the second was by date. I wanted to group the date
by weeks; however they want the range to be from Mon to Sun. The access
grouping is from Sun to Sat. Is there a way to change this?

Thanks,
Brian

You can use the DatePart() function.
it has an argument to set the first day of the week to whatever day
you want.
In code:
MyWeek =DatePart("ww",[DateField],vbMonday)

In the control source of an unbound control:
=DatePart("ww",[DateField],2)

See VBA help.