Take a little off the top :)

[ldodge]

Hi all--


I have a field called "ingredients" in which I list all the ingredients of various recipes. I would like to be able to delete all the NFDM (non fat dry milk -- for you non - dairy types hehehe) along with the comma that follows it.
Ex.:

Milk, NFDM, Flour, Sugar
go to:
Milk, Flour, Sugar

Any thoughts?
Thanks in advance
LCD

[boblarson]

I have a thought. My first thought is that you should not be storing multiple data in the same field in the same record. So, your table should be storing it like:

 
RecipeID IngredientID
1               1
1               2
1               4
2               1
2               4
2               3

where the ingredients table is something like

IngredientID      IngredientName
1                        Milk
2                        NFDM
3                        Flour
4                        Sugar

and so on. Then it is easy to add, subtract, etc.

[Rhino373]

I agree with Bob but you should be able to use the Replace() function to achieve this. You'd need to replace the word, comma and trailing space

[ldodge]

Thank Bob and Rhino, I will try those as soon as I get a moment
LCD