Results 1 to 3 of 3
  1. #1
    JAM7007 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    6

    Exclamation Query where each result consists of multiple data points from different rows

    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.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    A CROSSTAB query should be able to produce either of those outputs.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JAM7007 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    6
    Just exactly what was needed for my wanted results. This was of much help, June7.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 05-09-2013, 11:00 PM
  2. Replies: 1
    Last Post: 07-14-2012, 01:37 AM
  3. Help : Query based on data from multiple rows
    By GeorgeB in forum Queries
    Replies: 7
    Last Post: 03-28-2012, 11:27 PM
  4. Replies: 1
    Last Post: 12-03-2011, 01:26 AM
  5. Editing Multiple Rows of Data with (Ctrl F)
    By Orangeworker in forum Access
    Replies: 2
    Last Post: 11-11-2010, 03:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums