I have a value of say 30 in a table - stored as integer. I have a text box on my form that finds this does a query to find this number, but of course when its stored in the text box its stored as "30".
I need to run a query saying ... Where number_in_table = number_in_form
but number_in_form is a string, so it wont work properly.
Can anyone think of a way around this ?
I need to run a query saying ... Where number_in_table = number_in_form
but number_in_form is a string, so it wont work properly.
Can anyone think of a way around this ?