Parameter Queries Using >

  • Thread starter Thread starter LiseD
  • Start date Start date
L

LiseD

Is it possible to use a parameter query using greater than or less than?

I have a few field with numerical data that often require this but not sure
how to buld this into the query. So far I have just been using the between
from and to.
 
Is it possible to use a parameter query using greater than or less than?

I have a few field with numerical data that often require this but not sure
how to buld this into the query. So far I have just been using the between
from and to.
Click to expand...

The Query SQL Where clause would look like this:

Where YourTable.AField Between [From] and [To]

Where YourTable.AField >= [From] and YourTable.AField < = [To]

Either one of those lines, as criteria, will return the same result.
 
That is not quite what I am looking for.

I ONLY want to use the parameter => not from and to. I already know how to
do this. My question was how to use the greater than and equal to in a
parameter without using from to.

fredg said:
Is it possible to use a parameter query using greater than or less than?

I have a few field with numerical data that often require this but not sure
how to buld this into the query. So far I have just been using the between
from and to.
Click to expand...

The Query SQL Where clause would look like this:

Where YourTable.AField Between [From] and [To]

Where YourTable.AField >= [From] and YourTable.AField < = [To]

Either one of those lines, as criteria, will return the same result.
Click to expand...
 
That is not quite what I am looking for.

I ONLY want to use the parameter => not from and to. I already know how to
do this. My question was how to use the greater than and equal to in a
parameter without using from to.

fredg said:
Is it possible to use a parameter query using greater than or less than?

I have a few field with numerical data that often require this but not sure
how to buld this into the query. So far I have just been using the between
from and to.
Click to expand...

The Query SQL Where clause would look like this:

Where YourTable.AField Between [From] and [To]

Where YourTable.AField >= [From] and YourTable.AField < = [To]

Either one of those lines, as criteria, will return the same result.
Click to expand...
Click to expand...

So just use >=[From]
You have the =< backwards. It must be >=.

When prompted enter 250 and it will return all values from 250 and
greater.
 
Back
Top