Help with output format

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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
 
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.
 
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.
 
Back
Top