Calculating the WeekDay Names each month

[Steven M. Britton]

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

 

[Duane Hookom]

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