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

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.
 
G

Guest

Expr2: [JerseyNumber] Mod 2
CRITERIA -- >0
This divides number by two or multiple of two and list the remainder. Any
with remainder is odd.
 
J

Jason Lepack

It is called modulo.

1 modulo 2 = 1

In access I believe it's called mod

Cheers,
Jason Lepack
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP forumla for Excel HELP! 1
Include zero's on a query 3
Query selecting those players who played under par 4
ranking a query or report 1
Round up or down to nearest 5, but not 10 2
Create a summary list without using PivotTables? 8
Rank after Sort 1
Group by clause on 3 tables 1

Top