report grouping question

[Marc Dugas]

I am trying to complete a time management database. In
the report, I have a grouping level for date at one week
intervals so I can summarize a week at a time per
individual. The problem is, Access begins the week on
Sunday, and ends on Saturday, our work week begins on
Monday and ends on Sunday. I there an easy way around
this?

 

[Duane Hookom]

You could try change the grouping field/expression to:
=[YourDateField]-1

 

[Marc Dugas]

I get a syntax error when I do that: INT(([[Date]-1])-1\7)
\1.

-----Original Message-----
You could try change the grouping field/expression to:
=[YourDateField]-1

--
Duane Hookom
MS Access MVP
--

I am trying to complete a time management database. In
the report, I have a grouping level for date at one week
intervals so I can summarize a week at a time per
individual. The problem is, Access begins the week on
Sunday, and ends on Saturday, our work week begins on
Monday and ends on Sunday. I there an easy way around
this?

.

 

[Marc Dugas]

I apologize, that worked. I did not notice the equals
sign before it. Thank you!

-----Original Message-----
I get a syntax error when I do that: INT(([[Date]-1])-1 \7)

\1.

-----Original Message-----
You could try change the grouping field/expression to:
=[YourDateField]-1

--
Duane Hookom
MS Access MVP
--

I am trying to complete a time management database. In
the report, I have a grouping level for date at one week
intervals so I can summarize a week at a time per
individual. The problem is, Access begins the week on
Sunday, and ends on Saturday, our work week begins on
Monday and ends on Sunday. I there an easy way around
this?

.

.

 

[Duane Hookom]

Did you include the "="? Your expression doesn't look much like mine. You
could also try

=Format([Date],"yyyyww",2 )

--
Duane Hookom
MS Access MVP
--

I get a syntax error when I do that: INT(([[Date]-1])-1\7)
\1.

-----Original Message-----
You could try change the grouping field/expression to:
=[YourDateField]-1

--
Duane Hookom
MS Access MVP
--

I am trying to complete a time management database. In
the report, I have a grouping level for date at one week
intervals so I can summarize a week at a time per
individual. The problem is, Access begins the week on
Sunday, and ends on Saturday, our work week begins on
Monday and ends on Sunday. I there an easy way around
this?

.