Formatting a report

[fiel]

I'm trying to make a report that lists the names of all related workers horizontally across a report. Verticlly I 'm trying to list all tasks to a project on the left hand side. With this I want to display how many hours each worker spent on each task described on the left hand side of the report. The wizard isn't able to do this and I don't seem to be getting anywhere in doing this from scratch. Any ideas?

 

[Remou]

Have you looked at a Crosstab Query?

 

[fiel]

That kind of worked, but is there a way I could set it up to have several listings per each column so I could list the wages of each worker under and their position?

Example I'm trying to make something like this:

Staff 1 Name Staff 2 Name Staff 3 Name
Manager Associate Associate
$10.00 $5.00 $5.00

Task # Staff 1 Hours Staff 2 Hours Staff 3 Hours

1 5 4 4
2 4 4 4
3 8 7 8

Total Hours: 17 15 16
Earnings: $170.00 $75.00 $75.00

At the end, I would like to sum up all of the hours for each staff member and multiply their total hours by their wage.

 

[fiel]

Oops, I meant it to say $80.00 Under Staff 3

 

[Remou]

You can do that part in the report with subforms. Also, you can join crosstabs to tables and queries including other crosstabs, as far as I recall.

 

[fiel]

I got most of it working, but now i doesn't update whenever I add or remove staff members. I don't mind if columns get deleted when a staff member is removed, but how could I edit it so additional columns are added each time a new staff member is added?