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 |
#2
|
|||
|
|||
How to set the parameter query for this case?
klim1167 via AccessMonster.com wrote:
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 Try using a Where clause like: WHERE (Eng = EngMin Or EngMin Is Null) And (Eng = EngMax Or EngMax Is Null) -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|