Reports in Calendar Look 1

[llam]

Hi, I am having problem to generate reports in calendar look. I am currently working on a database containing all the vacation information for all staff. Vacations are stored as (Employee),(VacationStart),(VacationEnd). I would like to generate a report that organize the information as a calendar, such as:

             January          February       March
            Wk1 Wk2 Wk3 Wk4  Wk1 Wk2 Wk3 Wk4 Wk1 Wk2 Wk3 ...
(Employee1)         =======        ===
(Employee2)             ===      ===========
...

It is possible to generate a report similar to this in microsoft access? Thx!

--llam

 

[gnosis13]

Just to take a shot at this during lunch...

If you could somehow create a temp table by extrapolating the exact days from the Vacations table that has each employee and every day of the year, it would be very easy to print. Your temp table would look something like:

(Employee), (Jan1), (Jan2), (Jan3),...
--------------------------------------
Bart Simpson, X , X , O ,...

Of course, this will get you a failing grade in DBases 101.

I can't figure out how to get the actual days from the table you presented...back to lunch.
A+, N+, MCP

 

[llam]

Similar to yours, is it possible that I create a report with the detail part having squares (or other objects) for each week. Each time the detail part is being load for each employee, each square check itself whether it is within range of any vacation. If it is, it show itself or highlight itself. Do you think it works in microsoft access's reports? Thx!

<Vacation Table>
-> <Employee>
  ->  [] [] [] [] [] [] [] [] [] [] [] [] [] [] ...

Outcome:
Vacation Calendar
Employee1: [ ] [ ] [ ] [ ] [X] [X] [X] [ ] [ ] [ ] 
Employee2: [ ] [X] [X] [X] [X] [X] [ ] [ ] [ ] [ ] 
...

--llam

 

[bocker]

Check this out. Maybe you will use it, or maybe you will get some ideas.

http://www.referee-assistant.com/calcontrol.htm