Crosstab: need two values...

[easyit]

Hi,

I designed a registrationtool in which employees are logging their worked items (number of) and their workd hours.
Now I need to display their results for certan periods like:

name nrOfItems avgTimeNeededPer item thisweek lastweek weekbeforelastweek etc
worker1 10 0:15 16 0:05 2 1:15 ...
worker2 25 0:06 34 0:03 20 0:10 ...

My problem is that I don't know if it is possible to creat a crosstabquery for this. I can show 1 item, either the avg time or the nr of items processed.

Does anybody have any suggestion?

The goal for me is to creat a report in which manager can track the progress of employees, comparing the results over a period of time. Maybe crosstab is not the way to go?

Maarten

 

[PHV]

This FAQ may help you:

http://www.tek-tips.com/faqs.cfm?fid=4524

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

 

[easyit]

!! quick response and it seems to be what i'm looking for. I'll work it out and will let you know to you, thanks.

 

[easyit]

PHV,

Works great, thank you very much!

Maarten