I am query a database with a number entered into a text box.

i.e

select blah from moreblah where lessblah = " & evenlessblah & " "

the number, that is entered into the above mentioned text box ....and used in query, is a concatination of of a 4 digit sheet number and a 2 digit location number. the 2 digit location number is at the end of this whole number.
Can i query the db by using these 2 numbers alone? i.e
enter 121234 into a text ox and just query the db using the last 2 digit e.g 34??


Hope this is trivial to some of ye


sir stupidhead