Holiday/Vocation Planner

[Rob P]

Using Access 2003 I have been asked to create a staff/HR database. One
problem is that I cant seem to produce a form/report/chart showing staff
holidays booked in the format requested.

The tblHolidays has StaffID, StartDate, EndDate, NoOfDays,

The output is to look like a normal holiday planner eg

Name Dates
1/1.......................................................................................to.............................................31/12
Fred xxxxxx
xxxxx
Sue xxx xx

I have searched the web and news groups without success. It does not require
printing hence not limited in width

Has anyone any ideas?

Many thanks

 

[sebthirlway]

Hi Robert

what you need is a crosstab query - look this up in Help. Xtab queries
take data that's stored vertically (e.g. one row for each day Fred is
having on holiday) and pivots it up to the horizontal axis.
Because you can't rely on people booking holidays so that, on any
particular day, at least _someone_ is on holiday, you'll need a table
containing all the days in the period - otherwise the only days you'd
get across the top would be those where someone's on holiday.

cheers


Seb

 

[Roger Carlson]

This isn't directly related to your question, but it does relate to a
Vacation database. I was once asked to calculate the amount of vacation
used and how much was available. I put the process into a small sample
database on my website (www.rogersaccesslibrary.com) called
"VacationUsed.mdb". I thought this might be useful to you.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L