Data Tranformation thru Query???

[Debbie Hatten]

Hello all! I need some help with transforming some data
and I'm thinking I will have to do it through a query.
I've tried several different ways including a crosstab,
but I haven't had any luck. Here goes:

If I have a table (tMyData) that looks like this:

Account# Name
12345 Smith
12345 Jones
12345 Brown
67890 Jordan
67890 Bryant

Can I transform the data so that it looks like this:

Account# Name
12345 Smith Jones Brown
67890 Jordan Bryant

or even like this:

Account# Name Name Name
12345 Smith Jones Brown
67890 Jordan Bryant

I know the end result is bad design but I'm stuck.
Thanks in advance!

Debbie

 

[Duane Hookom]

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution involves writing one function that can be used for all
concatenation tasks.