Display data from multiple records in a single field...

[Wrangler36]

I have a table that displays data in the following format - (same field/multiple records):

ANIMAL TYPE:
DOG
CAT
HORSE
RABBIT
LION
TIGER

I need to display the names of the animals in a single field of a data entry form in the following manner:

ANIMAL TYPE: DOG, CAT, HORSE, RABBIT, LION, TIGER

Does anyone have any ideas on how I can combine data from multiple records of a table into a single field on a form?

Thanks,
EJ

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4233

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Wrangler36]

Thanks PHV! That is exactly what I needed. I have to remember to check the FAQs before I submit my posts.