Developer Forum

I have created a work schedule from a payroll system via
CrossTab query.

The result is as follows:

Department Position Shift Sun Mon Tues .....
01 03 Days Jon Jon Don
01 03 Nights Don Don Jon

My problem is this: There can be more than 1 person on
the same
department, position and shift on the same day.

I know that with a crosstab the group by on the row
headings is what is limiting my data.
When I try to do the group by with the Emp# I get this:

Department Position Shift Sun Mon Tues .....
01 03 Days Jon
01 03 Days Jon
01 03 Days Don

Which is not what I need. What I need is:

Department Position Shift Sun Mon Tues .....
01 03 Days Jon Jon Don
01 03 Nights Don Don Jon
01 03 Nights Tim Tim Joe

If you have any suggestions, advice or direction at all I
would really
appreciate it.

There is generic concatenate function that can be used as the Value in a
crosstab at
http://www.yqcomputer.com/ #Hookom,Duane. This
could combine your employee names as a single value.

--
Duane Hookom
MS Access MVP