Query Values with < > or =

  • Thread starter Thread starter Rillo
  • Start date Start date
R

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.
 
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.
 
Thanks for the help - much appreciated


Duane Hookom said:
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


Rillo said:
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.
Click to expand...
Click to expand...
 
Back
Top