Using Mod properly (1 Viewer)

I have a need to determine if a field is odd or even

Obviously my syntax is wrong but I can't see it

Any help would be appreciated

It is hard to know exactly what you are trying to do.
The first part has incorrect quotes. This is what you want there.




This section will concatenate that whole expression literally to the filter. Me doesn't register inside the form so it can't be right.

If this expression is evaluated in the VBA then it will return True or False. You would not put that in a filter but test it before building the filter.

Depends what you are trying to do.

Use a variable to get the filter string and view it to see if it is what you expect.

atrium said:

Obviously my syntax is wrong but I can't see it

Click to expand...

Galaxiom pointed out the problem with the syntax. Beyond that the logic is wrong.


anyEvenNumber Mod 2 = 0

sonic8 said:

Galaxiom pointed out the problem with the syntax. Beyond that the logic is wrong.


anyEvenNumber Mod 2 = 0

Click to expand...

True ... for even numbers ... but in post 1, it specifies odd numbers