Multiple entries into one field

[stephendeloach via AccessMonster.com]

I have a form with multiple records. In the records I have an Equipment field.
Is there a way I can query that field into a report and get all of the
entries into one field in the form??

example:
Field: Equipment Equipment Equipment Equipment
Entry: Mudboat Rig lift substructure Rig
lift



now in the report I need a field that pulls all the equipment and puts it
under the Equipment field in the report like... Mudboat, Rig lift,
Substructure

Is this possible? Please tell me yes! Thanks

 

[Allen Browne]

You can do that if you are comfortable with VBA code.

Here's an example:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[stephendeloach via AccessMonster.com]

Wow.. thats a little over my head. Thanks for your help though!

You can do that if you are comfortable with VBA code.

Here's an example:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

I have a form with multiple records. In the records I have an Equipment
field.

[quoted text clipped - 11 lines]

Is this possible? Please tell me yes! Thanks