even or odd records

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
How do I list records with only the even part numbers.
Click to expand...

In a Query?
EvenNumbers:[FieldName] Mod 2 = 0
The result will be -1 (True) if the value is an even number
The result will be 0 (False) if the value is an odd number

or...
OddNumbers:[FieldName] Mod 2 = 1
The result will be -1 (True) if the value is an odd number
Thwe result will be 0 (False) if the value is an even number
 
You must log in or register to reply here.

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

FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY 1
Odd and Even numbers 3
Even and Odd numbers 0
Select only even or odd number records 4
calculation based on previous record 0
Query or Report? Need to get addresses by odd or even numbers 10
finding unique values 3
Sorting by odd or even date 1

Back
Top