problem with between function?

[slenish]

Hello everyone,

I am having trouble with a query I have set up to check for a number range, but when you run the query which goes to a report the range is off by a lot.

To go in to more detail. I have a form set up with two text boxes. One for the start number and one for the end number. Then I have a button set up that runs a report printing out the records in the number range. For some reason when i do a number range starting with 1 - 9 and ending with any other number it pulls every record. But if i start with 10 and end with any number it works fine.

Any ideas or help with this would be greatly appreciated.

Thanks so much!

[TheSmileyCoder]

Is the field setup as numerical? I.e. its not simply numbers stored as text?

Post the SQL of the report (if that is where you reference your form, to perform the range selection)