Back again here in this wonderful forum. Hopefully i will be replying to these type of threads in the future, but as for today i need some help.
I work for a company where team members swipe under different job codes within a day. At the end of the day a metric report kicks out reporting how many "LinesPerHour" they have completed each day under each specific Job Code/Description (Job Code and Description have direct relation. 100 is Shipping, 200 is Picking, etc). In this report, there is a row for every metric for each person for each day. Metric Report looks just like this...
RptDate DC_User Jobcode Description LinesPerHour 6/10/2013 Pina, Delton 200 Picking 10 6/10/2013 Pina, Delton 100 Shipping 15 6/11/2013 Pina, Delton 200 Picking 20 6/11/2013 Pina, Delton 100 Shipping 25
Basically, i would like a query for each member. Each query would kick out results(row) for each Date; that row containing the "LinesPerHour" for each job code or description under corresponding column for that date, as shown below. Query will be pulled from a table in the same database that will hold all metrics, just like the table above. The query results for "Pina, Delton" should look this...
RptDate 100 200 300 400 6/10/2013 15 10 6/11/2013 25 20
or...
RptDate Shipping Picking Receiving Brakes/Rotors/Drums Inventory 6/10/2013 15 10 6/11/2013 25 20
(Sorry about the highlighting issue at the end of the two tables above; the color has no meaning)
I did a lot of researching before coming here to post and really could not find much of anything that could lead me in the right direction. Any help would be much appreciated.