Combining Records

[Agent_KGB]

I have a table that looks something like this:

AccountField FeatureNumberField FeatureNameField
Where each account has 30 records (one record for each of the 30 fields)

what i need to do, is combine all of the FeatureNameFields into one string.
End result would look something like this

AccountField FeatureField
where FeatureField would be a string of features from all 30 fields

any chance somebody can point me in the right direction?

 

[Dorian]

Your table is actually better organized (more normalized) the way it is now.
Why do you need to do what you are saying?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Agent_KGB]

because that's how i have to provide the output data...

i don't make the requirements... just try to comply with them ;0)

 

[KARL DEWEY]

For an output you do not need a table with the changes. Use a crosstab query.