Help with output format

[Terry]

I have this in a table:

100,V1,otherfields
101,V1,otherfields
102,V1,otherfields
103,V2,otherfields
104,V2,otherfields
105,V2,otherfields
106,V2,otherfields
107,V3,otherfields
108,V3,otherfields
109,V3,otherfields
110,V3,otherfields
111,V3,otherfields
112,V4,otherfields
113,V4,otherfields

....and i want two of the fields displayed in this format on a report:

V1,100,101,102
V2,103,104,105,106
V3,107,108,109,110,111
V4,112,113

I've tried a few ways, including crosstabbing - which didn't work. Any help
would be gratefully received.

Terry

 

[Duane Hookom]

Check the demo download of Generic Concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Come on
back if you have a question.

 

[Terry]

Thanks Duane, I've downloaded the demo and i'm currently trying to see how i
can apply it to the data in my single table.

Terry

 

[Duane Hookom]

There is no such thing as a "single table" in Access. By creating a filter
or group by or other functionality in a query, you can "create" thousands of
"virtual" tables to meet your needs. Starrt with a query that
SELECT DISTINCT VField
FROM tblYourTable;
Use this new query as the base for you report and add the column with a
concatenate function.

 

[Terry]

Oh ok, my SQL skills haven't yet stretched that far. I'll look into it a bit
deeper now that i've got a few days off work.

Thanks again for your help and advice.