Having Trouble Trimming Text

I have a table that has text eg: MyText#OtherText#. I would like to keep the text to the left of the # symbol but get rid of all text to the right of the # symbol. Can anyone help me with this

Thanks In Advance
Jon

varaible = left([TableField],instr(1,[TableField],"#")-1)
S-

Could you give me a better explantion as to what to do with the string you provided. Do I use this in a qry?

Thanks
Jon

What do you want to do with your new value, all I gave you was the code (to be used in as a query expression, or in VBA).

S-

I have 400 records that I want to get rid of the # symbol and all the text to the right of it eg:

eggs#bacon#
toast#jam#
Orange#Juice#

I want to eliminate the #bacon# from the eggs#bacon# etc. So I am left with eggs etc in the Products field of my table.

UPDATE Table3 SET Table3.Product = left([Table3.Product ],instr(1,[Table3.Product ],"#")-1);

S-

It worked Thank you very much

Jon