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
Code:
Me.Filter = "(UserId = " & Me.UserIdFld & " OR ActionDueDate <= (Date() - 21)) & " AND ((Me.MatterShortNo) MOD 2 = 1)" ' and Matter number is Odd
Obviously my syntax is wrong but I can't see it
Any help would be appreciated