Help with a report

[muskee]

Hi guys!

I would kindly appreciate your help!
I need a report for my employees uniforms. I have the employee table where I have these variables:
employeCat, shirt size, shirt amount , pants size, pants amount, shoe size, shoe amount          (employeCat can be administrative, designer, reception)

So, I made 3 summary fields to add up the amounts and thus obtain the totals of each item.

Soo, I'm having problems when creating the report, can't get it to work.

For example, I need to see the shirt size L and see how much shirts I need for that size and the amount for the category the employee is in.
I. E Shirt size L, 11 required for category Administrative
Pants size XL, 7 required for category Designer
Same for shoes....

And of course eould also need a grand total at the bottom

Thanks for your help!