Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ages

Status
Not open for further replies.
JimSmitty

JimSmitty

MIS
Aug 3, 2000
7
US
I'm still working on calculating age even after i looked at the FAQ's. My problem is...<br><br>I got the age to work from the calculation of ages except when it has a date before 1930, it has a problem calculating and gives a negative number. Does that make sense? Can you help me? I am using access 97 <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>
 
Sort by date Sort by votes
The Short Date setting assumes that dates between 1/1/00 and 12/31/29 are twenty-first century dates (that is, the years are assumed to be 2000 to 2029). Dates between 1/1/30 and 12/31/99 are assumed to be twentieth century dates (that is, the years are assumed to be 1930 to 1999).
 
Upvote 0 Downvote
So, how is that supposed to help me? What do I do to make it work...???<br> <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>
 
Upvote 0 Downvote
The simplest thing would be an if statement like <br><br>if age &gt;= 0 then results else 100 - age<br><br><br><br>
 
Upvote 0 Downvote
oops!!! sorry about that it should read...<br><br>if age &gt;= 0 then age else 100 - abs(age)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Guest_imported
  • Locked
  • Question
Calculating Ages
Replies
1
Views
41
Guest_imported
Guest_imported

Part and Inventory Search

Sponsor

Back
Top