I have a list of employees that are hourly paid. I have regular pay, over time pay, and double pay. These employees put in hours every single day. I need to make a report that would show the days of the week that they worked for and their hours that they have put in. For Ex:
1/2/02 1/3/02 1/4/02
RT OT DT RT OT DT RT OT DT
MrX 8 2 0 8 4 0 8 4 3
MrY 8 3 0 8 5 2 8 2 6

I have tried making a cross tab query, but it can only do the Regular Time individualy. I have to make 3 different cross tabs, but when I combine them it does not give me the result that I want. Please help. Is there any other way of doing this? Thank you all for your help http://www.access-programmers.co.uk/ubb/smile.gif