Originally Posted by
Minty
That sounds as if you don't have a normalised data structure.
Each ingredient should be a single record in a table of ingredients linked back to a master record (Recipes? , Bomb Ingredients? Etc.)
That way whether you have 1 , 10 or 100 ingredients your design copes with it.
To answer your question you would create a calculated field;
MyList: Active_Ingredient_1 & ", " & Active_Ingredient_2 & ", " & Active_Ingredient_3 & ", " & Active_Ingredient_4 & ", " & Active_Ingredient_5
To get clever with it if any ingredient is missing you could utilise the NZ() function.