View Single Post
  #3  
Old June 7th, 2010, 02:30 PM posted to microsoft.public.access.queries
Krzysztof Naworyta
external usenet poster
 
Posts: 80
Default How to set the parameter query for this case?

klim1167 via AccessMonster.com wrote:
| Dear all,
| I have 2 fields, Eng and Math.
| I would like to set the parameter query for Eng and Math == Eng min,
| Eng max, Math min and Math max.
| The Eng query criteria can be "Between Eng min AND Eng max" and the
| Math query criteria can be "Between Math min AND Math max".
| But...if I would it can be allowed to have "Null entry", how can I
| set the Eng and Math query criteria?
| Please kindly help me, thanks a lot!!
|
| All combinations will be like...
| Eng : Between Eng min AND Eng max, Between Null AND Eng max, Between
| Eng min AND Null, Between Null AND Null
| Math : Between Math min AND Math max, Between Null AND Math max,
| Between Math min AND Null, Between Null AND Null

(...)
Eng Between Nz([Eng Min],0) and Nz([Eng Max], Eng)
AND
Math Between Nz([Math min],0) and Nz([Math max], 200000000)



--
KN