input

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

 

[Michel Walsh]

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

 

[Kevin]

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

 

[\Allen Iverson\]

Thanks, It works fine.

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

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.

 

[\Allen Iverson\]

Thanks, It works fine.

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.


.