Horizontal Formatting of a Report

[bmelancon]

I consider myself new to access even though I've been working in it for a while. So I will apologize in advance. I will try to explain as best as I can. I am having a problem with the formatting of a report. My boss would like for the report to show (grouped by employee name) a horizontal list like below and update itself.

Aircraft AS350 A119 AW139 AW189
Training Hours 300 50 25 160
OJT Completion 85% 100% 25% 45%


Each training class has a category in the table showing which model(s) the training is. For OJT I got it to count up the tasks and tasks completed in each model and calculate the percentage. I can easily get it to show vertical for each employee. I cannot get it to show like above. I tried using IIF statements to pull the hours and OJT by model aircraft. If I try to put it in the detail section it shows vertical and if I put it in the group of employee name it only returns one record (I assume its still trying to show vertical). The only way I could think of to get it to show properly was a crosstab query but its my understanding those are for archival purposes or for a snapshot and do not update. This report will need to update as things are entered.

Any suggestions will be GREATLY appreciated! We have 600 employees so compacting reports is almost a necessity. :banghead:

 

[JHB]

The only way I could think of to get it to show properly was a crosstab query but its my understanding those are for archival purposes or for a snapshot and do not update. This report will need to update as things are entered.

Whether a report is based on a table/ query/ crosstab query - it will not update automatically anyway, only if you have something that triggers it to update.
When the number of columns vary is a (crosstab) query probably the only suitable to show results - a report can not automatic create column controls, then you've to do it by code.
So the question is, why it should be in a report?