Hi,
I have a text box on a form (format is 'General Number' in the property sheet). I want the query that I run to only show results which are equal to or less than this number.
In my query I therefore have [Forms]![SearchF]![Price] < = "x" in the criteria. However, when I run the query, it doesn't take the number entered into the form into account.
I have attached a screenshot of my query design.
Any help?