Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Sum and bring unique fields along

    I have the data in the small test database attached. I can write a query that sums up by Employee,DOS and ID. However, I can't find a way to get the code numbers to come along and sit on the same line.

    In other words, when Chuck is summed up he will have only 1 line. I want the three codes to be on the same line. Same with Bob. Is there a way in query to do this?? I tried to put the data here but it won't line up so I had to attached a small database. Any help is appreciated.

    Max
    Attached Files Attached Files

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    One way would be this type of thing:

    Modules: Return a concatenated list of sub-record values
    Paul

  3. #3
    Join Date
    Sep 2009
    Posts
    2

    Overwhelming

    I appreciate the help but his looks a little overwhelming. What goes where?? I wish I understood VBA better.....

    Max

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •