input

  • Thread starter Thread starter \Allen Iverson\
  • Start date Start date
A

\Allen Iverson\

How do you write a query which will take input as range criteria? Say, I
want to extract students whose GPA is between an input range. Thanks.
 
Hi,


Supply the two limits, two parameters, one per limit:

.... WHERE FieldName BETWEEN [param1] AND [param2]


Or you meant something else?



Hoping it may help,
Vanderghast, Access MVP
 
In the query builder, simply put the following in the
criteria line under GPA: Between [Low] And [High]

The user will be prompted with whatever you have between
the brackets. You can use this same idea for dates or any
other ordered sequence. Just make sure your data types
are set right.

HTH
Kevin
 
Thanks, It works fine.

Michel Walsh said:
Hi,


Supply the two limits, two parameters, one per limit:

... WHERE FieldName BETWEEN [param1] AND [param2]


Or you meant something else?



Hoping it may help,
Vanderghast, Access MVP


"Allen Iverson" said:
How do you write a query which will take input as range criteria? Say, I
want to extract students whose GPA is between an input range. Thanks.
Click to expand...
Click to expand...
 
Thanks, It works fine.



Kevin said:
In the query builder, simply put the following in the
criteria line under GPA: Between [Low] And [High]

The user will be prompted with whatever you have between
the brackets. You can use this same idea for dates or any
other ordered sequence. Just make sure your data types
are set right.

HTH
Kevin

-----Original Message-----
How do you write a query which will take input as range criteria? Say, I
want to extract students whose GPA is between an input range. Thanks.


.
Click to expand...
Click to expand...
 
Back
Top