If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to set the parameter query for this case?
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 -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|