Parameter Queries Using >

[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.

 

[fredg]

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.

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.

 

[LiseD]

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.

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.

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.

 

[fredg]

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.

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.

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.

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.