Calculating Age - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Calculating Age

Eddy Geijselaers

5 years ago

Hi Rick,

I am trying to build a form in Access which should show age in years, month and days plus a field with a running clock for the hours, minutes and seconds.
The clock is not a problem so far.
calculating the age is.
Older peoples age is: 1943 gives an age of -22.
1920 gives age 1 !!
Must be an date/time option in either access or windows 10 which I could not find yet

Is it possible to make a digital clock run backwards (on the same form as a normal running clock?

I like to see age and time (yy,mm,dd) and time running back till date of retirement.

Thanks

	Richard Rost @Reply 5 years ago
You must be calculating age wrong. I have a function in the Code Vault called HowLong which will return values like "25 years, 3 months, 5 days." Just couple that with the timer on a 1 second delay, and there you go.

	Eddy Geijselaers OP @Reply 5 years ago
I calculate the age in a query with your Datediff - Dateserial combination and all the other ages coming out correctly. For the timer I use just the time (Date()+1 - date() formatted in time hr, min and sec. witch works fine for countup timer. Counting down on the same forms (til date retirement) does not work (yet). Probably I have to use a separate form. Thanks

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View