combing rows into 1 field

[millarjeremy]

so in my example you have a Weld (tblWelding_WeldingID) and each weld can have more than 1 consumable (tblconsumables_consumableID). have a third table that links the two, trackID,consumableID, weldingID)

What I need to be able to do in a report, is under the heading COnsumable, list the 1 or many consumables.

Also you select the consumable from a combo box..... if that just makes it that much harder..... any questions please let me know... THANK YOU

 

[John Big Booty]

Welcome to the forum.

Perhaps the article here will help you.

 

[millarjeremy]

YOU ROCK.... worked a treat