Query Values with < > or =

[Rillo]

I would like to display a form on which the user can enter a value (e.g
$1000) and then select either > < or = from a list box (e.g <$1000)

I want to have a query based on the user's selection.

In the above example, the underlying query would display all items with a
value of less than $1000.

I thought I could enter something like this in the criteria of the query....

[Forms]![Enter Value]![Comparator]&Forms![Enter Value]![Value]

but Access does not seem to like this.

I would appreciate any advice.

 

[Duane Hookom]

You can't do it that way. I generally use a Max and Min text box so your
query criteria can use one, both, or none by entering different values.

 

[Rillo]

Thanks for the help - much appreciated

You can't do it that way. I generally use a Max and Min text box so your
query criteria can use one, both, or none by entering different values.

--
Duane Hookom
Microsoft Access MVP

I would like to display a form on which the user can enter a value (e.g
$1000) and then select either > < or = from a list box (e.g <$1000)

I want to have a query based on the user's selection.

In the above example, the underlying query would display all items with a
value of less than $1000.

I thought I could enter something like this in the criteria of the query....

[Forms]![Enter Value]![Comparator]&Forms![Enter Value]![Value]

but Access does not seem to like this.

I would appreciate any advice.