Range Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that contains sequential numbers. The user want to run various reports on different ranges, more specifically like this "<3280 And >3314" which I can do if I type it into the field's critera. But if I set it up so that it prompts the used to enter that range value I get and error message stating that it's to complicated to be evaluated. Any help is appreciated in finding a solution. Thanks, Paul
 
It would help if you posted the SQL statement you have tried. I suspect that
you are using the query grid and trying to use two parameters.

Try adding the field to the query grid two times.
In the same criteria line, put criteria under the fields.

Field: FirstTime
Criteria: < [Enter Lower Limit]

Field: SecondTime
Criteria: > [Enter Upper Limit]
 
Have you tried using BETWEEN instead of < and >?

pas926 said:
I have a field that contains sequential numbers. The user want to run
Click to expand...
various reports on different ranges, more specifically like this "<3280 And
3314" which I can do if I type it into the field's critera. But if I set
Click to expand...
it up so that it prompts the used to enter that range value I get and error
message stating that it's to complicated to be evaluated. Any help is
appreciated in finding a solution. Thanks, Paul
 
Back
Top