odd numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
IF you are using the query grid, then this will look something like.

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