Combining Records

  • Thread starter Thread starter Agent_KGB
  • Start date Start date
A

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?
 
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".
 
because that's how i have to provide the output data...

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