I have a field that has a number somewhere in it. I want to know that number so my query can tell Access to do an action. If the number is 27 print 100 but if the number is 54 print 100. The field looks like this "variable number of characters 27 variable number of characters"
Can you tell me how to do this?
Thank you for your time.
Bill

http://msdn.microsoft.com/library/de...ctinstrrev.asp


INSTR function, searches for a string within a string, and returns the position where it starts at or 0.

if it returns > 0 then it found the string

Hope that helps!