Matrix Style Report

[hobman]

Hi, I am new to this and wondering how I can accomplish the following.

I have Initials for employees,
I also have categories of work they have done
I want to display it like this:

Category Total hrs HGB AKA JFK
Dish 50 20 10 20
burger 20 10 5 5
Yard 10 5 3 2
Totals 80 35 18 27

Can anyone help plese? Thank you in advance.

hobman

 

[PHV]

Have you tried a CrossTab query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hobman]

Thanks PHV, that's that's the name I was looking for!