Help for Dlookup() Numeric Data

[rkalapura]

Can Anyone help me in the following (Access 2010):

1. Dlookup("[KIT ID]", "[TOOLS]", "[BTN NO1] = "&[BTN SERNO])
2. Dlookup(("[KIT ID]", "[TOOLS]", "[BTN NO2] = "&[BTN SERNO])
3. Dlookup("[KIT ID]", "[TOOLS]", "[BTN NO1] = "&[BTN SERNO] or "[BTN NO2] = "&[BTN SERNO])

No.1 and No.2 is working fine. But No.3 when combining with "or" is not working. Where I am going wrong?



Note: Data Types [BTN NO1], [BTN NO.2] AND [BTN SERNO] Fields are Numbers.

Thank you in advance for your help.
Best regards

[aytee111]

"&[BTN SERNO] & " or [BTN NO2]="

[rkalapura]

Thank you very much for your help. That works like a champ!
Best regards