Thanks to both of you. It worked great! Now, if only I had posted here
sooner...



Marshall Barton wrote:
I am new to Access Monster. I have been searching for days to find the
answer to my query question.
[quoted text clipped - 18 lines]
I believe I need to write some variation of an IIF statement with the Mod 2
function in it somewhere, but I never get the syntax right.

Right. Add another condition to the query's Where clause
WHERE (whatever you have now) AND [Address#] Mod 2 =
Forms!searchform.[txtAddress#] Mod 2


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/201005/1