Display data in columns across top of page

[jh3016]

I have a table with sick and vacation dates that the employee takes off. I would like to have a report with the months as the column heading going across the page. In the row would be "Sick" or "Vac" (depending on what the employee took) and the date taken and the amount of time the employee took. In other words, here's a sample of January and Feb. I would want to continue this for the entire year. When I input into the table, I'm inputting the entire date (mm/dd/yy).

Jan Feb and so on
Vac 1/10/03 7.00 Vac 2/1/03 7.0
Sick 1/15/03 3.00 Vac 2/2/03 7.0

Is there an easy way to do this? I'm a newbie.

 

[dhookom]

You could create a subreport (just a report with no page settings) that is formatted and sorted just the way you want. In the record source query of the subreport add a calculated column:
Mth:Month([DateTaken])
Then create your main report with twelve text boxes across the top with names and control sources of:
txtJan =1
txtFeb =2
txtMar =3
etc
txtDec =12
The add 12 copies of the subreport, one under each text box. Set the link master child properties
Link Child: [mth] Link Master:txtJan
Link Child: [mth] Link Master:txtFeb
Link Child: [mth] Link Master:txtMar
etc
Link Child: [mth] Link Master:txtDec

This should limit the records displayed in each subreport copy to only the one month.