Quick Quetion

[irishvber]

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

[Bonker Gudd]

You could try something like:

select blah from moreblah where (lessblah % 100) = 34

Do not attempt this if you have a vegetable on your head.

[irishvber]

yeah cheers

pog mo thoooooooooiin

[irishvber]

anyone wish to help

[Bonker Gudd]

Did you try my filth?

[swatty]

evenlessblah = evenlessblah mod 100
'if it is a number
evenlessblah = right$(evenlessblah,2)
'if it is a string
 
select blah from moreblah where lessblah = " & evenlessblah & " "