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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
one field with number of features to be linked to feature descript 13
This has got to be an easy question? 9
Select records based on isolated portion of string 1
Group by Non-blank Distinct Values 5
appending new records to a table with a compound primary key 9
join two queries 1
Remove Duplicate - Count Number of Unique Results 5

Back
Top