I'm not a programming guru, so use nice small words! <G>

I've got a database where one of the fields is called 'participants'. In that field could be between 1 and 30 names, separated by commas.

What I'm trying to do is write a query/macro/code (whatever works) that will grab the individual names so I can spit them out to a mailmerge to print certificates. I've played with the instring, trim, left & right commands and can't find a combination that will do what I want.

If anyone knows a better forum than 'general' for this question, by all means let me know and I'll post it there.

Thanks in advance...Tepin

In the first place, why do you have just one field that contains what amounts to multiple records? Sounds like poor database design.

If there is nothing you can do about that, you would probably have to write some VBA code to parse through the string one byte at a time looking for the comma.

__________________
John F