How do I write a query for all those that have an odd value?

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

Guest

We have a database of football players. One of the data fields is "Jersey
number". How do we write a query to list out all players with an Odd jersey
number.
 
Expr2: [JerseyNumber] Mod 2
CRITERIA -- >0
This divides number by two or multiple of two and list the remainder. Any
with remainder is odd.
 
It is called modulo.

1 modulo 2 = 1

In access I believe it's called mod

Cheers,
Jason Lepack
 
Back
Top