Traspose / Combine Data

[patfee]

hi,

is it possible to transpose / combine table data through a query as explained below:

Column1 Column2 Column3 Column4
A B
A C
A D

to:
A B C D

or to (even better for what i'm trying to achieve):
A B/C/D

Thanks,
Patrick

 

[MichaelRed]

See CrossTab (query) or transpose. Both are addressed in the ubiquitous {F1} (aka Help) azs well as in numerous threads in these fora. To even ask this question with oout having researched (and cited your research efforts) suggest that you are just asking others to do your work.


MichaelRed

 

[dhookom]

Patrick,
There is a generic concatenate function at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

that can create your B/C/D result.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]