Further help required !!

J

Jacob Frankham

Hi Dennis

This is a copy of a posting to a previous reply from a different user,
hopefully I might get a reply from one of you !!

Lets say I have a query which produces employee dept data - there are 2
fields output from this query: ie

dept and empName

On my report, I am grouping by dept, and underneath each grouping (ie
underneath each dept name) I want to write a list of all of the empNames
separated by commas.

Now the code which you have supplied DOES list the empNames separated by
commas, BUT it lists ALL of the empNames in the whole of the query, NOT just
the empNames applicable to the relevant dept

Thus, if dept '102' appears 5 times (5 employees), I want those 5 empNames
to be written (separated by commas) underneath the dept on the report, and
so on for the next dept.

At the minute, ALL employees are being output under EACH dept grouping.

I hope this makes sense, thank you for your help so far, much appreciated

Cheers

Jake.
 

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

Similar Threads

Multiple IDs for same Employee 5
UNION query 11
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Input for reports from a form 3
Sorting within Groups 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report sorting 1
Crosstab not showing null values/fields 5

Top