odd numbers

J

jimtodd

I have a Query which shows how many times a certain number occurs.
If this number is even then thats ok but if its odd it's not ok and I need
to know about it. So how do I set criteria in a query to show only odd
numbers.
Using Access 2003 pro
 
B

Brian

jimtodd said:
I have a Query which shows how many times a certain number occurs.
If this number is even then thats ok but if its odd it's not ok and I need
to know about it. So how do I set criteria in a query to show only odd
numbers.
Using Access 2003 pro
Click to expand...

WHERE some_number Mod 2 = 1
 
J

John Spencer (MVP)

IF you are using the query grid, then this will look something like.

Field: EvenOrOdd: [YourTable].[YourNumberField] MOD 2
Criteria: 1
 
Top