HELP WITH A REPORT LAYOUT

V

vvwilson

I am creating a report that looks like a time card. My input for my
data is via a form that utilizes a duplicate last record. As a result
my employees names, task (labor control #) and the hours worked on the
labor control # show up in my report as a vertical list. I am
looking to have the name, labor control # and hours show up on the
same line.

Example Of What I Have:

Joe Smith 6a-1901 6
Joe Smith 6B-1201 2
Joe Smith 6C-1401 2


Example Of What I Want: Joe Smith 6A-1901, 6B-1201, 6C-1401 6, 2,
2. In this example Joe worked on three different labor codes for a
total of 8 hours.
 
G

Guest

Look back through this news group for:
Subject: RE: Concatenate values of one field from multiple records in query
8/26/2007 6:28 PM PST
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top