creating report with calendar

[stella]

Hi all!

I've created is a DB that records day to day employee
schedule with codes that refer to the shift that they are
working at within a particular day. I have a table with
just employee info, and then another table with schedule
information which you can tie up using the SSN.
Basically, the user of the DB needs to enter in the date
and the code in the schedule table.

How can I create a report that lists a weekly or monthly
schedule with the names of the employees on the left
column and the dates of the week/month horizontally
stretched across the report. Is there a way to do this?
From what I've seen, the report lists the dates on one
column going down.

I know I can make a crosstab query, but can I make this
into a report instead?

Any help would be greatly appreciated.

Thanks!

 

[Fons Ponsioen]

You can use the report wizard to create a report from a
crosstab query. Where I have used it the result were very
good.
Hope this helps
Fons

 

[Guest]

Fons,
I get how you can put the dates as column headings but the
data would be grouped per date, meaning employee A would
have 31 rows of data per month instead of just one row
with each column filled in. Can you tell me how to solve
this problem?

 

[SA]

Stella:

Stop by this link for examples of calendar reports created by Duane Hookom
Access MVP

http://www.invisibleinc.com/download.cfm?filFilID=6

HTH

 

[SA]

Anon:

Stop by this link for examples of calendar reports created by Duane Hookom
Access MVP

http://www.invisibleinc.com/download.cfm?filFilID=6

HTH