Sorting by odd or even date

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

Guest

I am looking for a way to write in code If an entered year is odd then
[another field]= 1 and if the entered year is even then [another field] = 0

The [another field] is used as part of a query that gathers either all the
odd or even numbered records for a report.

Thanks
Mark
 
Use Mod 2 to determine odd/even.

In query design, you could type something like this into the Field row:

IsOdd: (Year([MyDate]) Mod 2) = 1))
 
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

Odd Cursor Behaviour 22
Select only even or odd number records 4
SORTING BY ODD OR EVEN NUMBERS 1
Odd Subform behaviour 4
Validation Rules for a Control on a Form (?) 4
Weird form issue 1
Sorting of data in a subform 2
Can a Check Box Prevent Other Fields from Being Used? 1

Back
Top