Extracting Odd/Even or Both Numbers

[matomo]

Hi all,

In my query I can query for ODD or EVEN Street Numbers using the syntax below:

OE: [PROPHOUSENUMERIC] Mod 2

This works fine returning just odd or even numbers.

Now the problem I am facing now is that I wan the same query to return both Odd and Even Street numbers if I did not ask for either Odd or Even Street Numbers.

Is this possible. I have search hi and low in the forum but no answer. I have attached the file I am working with this post.

Thanks in advance.

matomo

 

[Access_guy49]

Possible fix.

I THINK i got it to do what your looking for.
I created a copy of your query, and of your report. The query was changed and the odd or even thing was done away with. (called qr2) then i copied your report and changed the source of the report to the new query. then i added a value to your odd even table to allow for a null value. then in your ok button i added a little if statement to check if it's null or if it's one of the odd or even selections. it's probably not the only way to do it, or the best way. but simple and it works.
(attached is my changes to save you some time)

 

[matomo]

Access Guy49,

Thanks you for the fix.

matomo