odd/even numbers

R

Ron Darby

I am making a report and need only the records that contain odd values in a field of integers. Is there a function or somthing that I can use?
 
F

fredg

I am making a report and need only the records that contain odd values in a field of integers. Is there a function or somthing that I can use?
Click to expand...

Sure.
If [SomeField] Mod 2 = 0 Then
' it's Even
Else
' It's Odd
End If
 
Top