query result inquiry

  • Thread starter Thread starter David Bartosik MS MVP
  • Start date Start date
D

David Bartosik MS MVP

If you run this and the Birthdate is 9/1 I come up with -1 for the result.
Wondering why this would not be zero or 1

Int("0901"<=Format(Birthdate,"mmdd"))



David Bartosik MS MVP
www.davidbartosik.com
 
In Access, -1 is true, 0 is false. In some other programs, 1 is true and 0 is false.

The reason is basically that this was a choice made by the designer/programmers.
 
Back
Top