I have a report that runs of a query based on a date
range. At the top of the report I have labels that go
from 1 through 31 and what I want to do is underneath
number one if I was in the Month/Day/Year 06/01/2004 it
would read Friday and under 2 read Sat... And so on and so
forth. But it needs to be calculated, so when we run
thereport for say 01/01/2003 underneath 1 it would read,
Wed...

My criteria is:

WHERE (((PAYROLL.DATEPERFMD) Between forms!
[frmCheckInReport]!StartDate And forms![frmCheckInReport]!
EndDate

Any help or ideas.

-Steve

Isn't there another NG with this same question/thread? If so, please keep
the posts in the original. If not, let us know.

--
Duane Hookom
MS Access MVP
--

"Steven M. Britton" <(E-Mail Removed)> wrote in message
news:1ab1c01c44f1b$32267930$(E-Mail Removed)...
> I have a report that runs of a query based on a date
> range. At the top of the report I have labels that go
> from 1 through 31 and what I want to do is underneath
> number one if I was in the Month/Day/Year 06/01/2004 it
> would read Friday and under 2 read Sat... And so on and so
> forth. But it needs to be calculated, so when we run
> thereport for say 01/01/2003 underneath 1 it would read,
> Wed...
>
> My criteria is:
>
> WHERE (((PAYROLL.DATEPERFMD) Between forms!
> [frmCheckInReport]!StartDate And forms![frmCheckInReport]!
> EndDate
>
> Any help or ideas.
>
> -Steve