report grouping question

  • Thread starter Thread starter Marc Dugas
  • Start date Start date
M

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?
 
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
--

Marc Dugas said:
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?
Click to expand...


.
Click to expand...
 
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
--

Marc Dugas said:
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?
Click to expand...


.
Click to expand...
.
Click to expand...
 
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
--

Marc Dugas said:
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
--

Marc Dugas said:
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?
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top