Grouping multiple rows

[AccidentalFate]

What i am trying to do is group the raceways and have one row for each raceway... do this by grouping the packages and seperating them by ", "

is this possible in a query or do i have to use a module?

so i want it to look like this

Raceway Package
1EECBX01 1APC-01, 1BMC-01, 1CCC-01, 1CCC-02, 1CCC-03, 1CCE-01, 1CCE-02, 1COA-01, 1WSC-01, CSTG-03

 

[DJkarl]

Checkout Crosstab Queries in Access

 

[AccidentalFate]

i don understand how they work...

 

[jal]

I haven't learned how to set up crosstab queries either.

I know that they can do, though. What I mean is if you want to find out what the results look like, play around with pivot tables in Excel or Access. A pivot table allows you to rearrange column and row layouts - and show groupings and subtotals - in very convenient and powerful ways. In essence, each cross tab query produces one of the many layouts available in pivot tables.

In fact, one solution feasible for some employers is to just dump the table into Excel and then show the users how to use Excel pivot tables - they can then set up as many different layouts as they want, once they get the hang of it.

 

[AccidentalFate]

pivot table... hmm...