I have a text box that I am entering an end value into, say 15.
I am using this text box in a query as criteria - = Forms![frmReports]![txtEndCriteria].
I would like to return all values that are less than 15 - the value I enter into the text box.
One problem. The field in the query that I am using for criteria is a text field (which I can't change). This not allowing me to return the proper values. It seems to view 999 as 9 and 199 as 1 - therefore my query is returning the wrong values.