Field displayed as a record

[DavidMack]

Using a querry, I want to display a field as a record.

Table A has an ID Field, Company Field and Name Field.



Let say 3 people are assigned to the Chocolate company. I want my querry to display the ID, the company and then the next column Bob, the next column tina, the next column Sue.

I've tried using a total's querry and it works using Max and Min for the Name field...but doesn't due me much good if there are more than 3 names.

[pbaldy]

Would this work for you?

Return a concatenated list of sub-record values

[DavidMack]

Well if I understood it correctly the result would return one string from multiple fields...I only have one field that i really need to be modified.

I used the code but unfortunatly it did not work for me...

[pbaldy]

Well, it returns one string from a field in multiple records. The only difference that I see between your request and that method is that it returns a single, comma delimited field instead of multiple columns.

[ssanfu]

Have you looked at a Crosstab query? There is a wizard to help create it.

[DavidMack]

Yes...and if i only had 2 name i could use the min / max options....but i have more than 2 name so in most occasions im missing data..

[ssanfu]

I haven't done it, but I read somewhere, someone ( yeah, right!!) used the crosstab query wizard to create the SQL, then edited the SQL to include more fields. I'm just saying......possible???