Return the text before a comma

[jon98548]

I have a description field that starts with a basic name of an item followed by a comma and the more descriptive text. I would like to return everything before the comma and truncate the rest. I can do this in Excel with:

=LEFT(A1,FIND(",",A1)-1)

but Access doesn't recognize Find. Thanks for any help you might have.

 

[pbaldy]

Try the InStr() function.