combining multiple field values into 1 list string

R

Ruthie

Hi, I received data that has i record for each specialization (and there are
100 specializations) -- so if 1 individual has all the specialties, I will
get 100 records (the individual info is all the same except for that 1
specialization field)

I was able to get a unique individual record with 100 specialization fields.
How do I then turn around and combine those 100 specialization fields into 1
list string --maybe delimited by commas?

Do you have a suggestion on how to treat these records?

Thanks for any help/suggestions/work-around.
 
J

John Vinson

Ruthie said:
Hi, I received data that has i record for each specialization (and there are
100 specializations) -- so if 1 individual has all the specialties, I will
get 100 records (the individual info is all the same except for that 1
specialization field)

I was able to get a unique individual record with 100 specialization fields.
How do I then turn around and combine those 100 specialization fields into 1
list string --maybe delimited by commas?

Do you have a suggestion on how to treat these records?
Click to expand...

You need a little easy VBA code to do this. For sample code see

http://www.mvps.org/access/modules/mdl0004.htm
 
K

KARL DEWEY

You are defeating the purpose of a relational database.
You should have three tables -
Individual -
IndivID - autonumber - primary key
DOB - datetime
addr - text
phone - text
etc

Speciality --
SpecID - Autonumber - primary key
Title - text

Specialization --
IndivSpecID - Autonumber - primary key
SpecID- number - long integer - foreign key - related to Speciality table
IndivID - number - long integer - foreign key - related to Individual table
AssignDate - datetime
RescindDate - datetime
Remarks - memo

Speciality table will be related to Specialization in a one-to-many.
Individual table will be related to Specialization in a one-to-many.
 
R

Ruthie

thanks and I have that -- I created the following tables - Customer,
Specialties, Validation --
 
Top