IN ACCESS NEED TO INCREASE AGE COLUMN BY A YEAR

Y

yvonne

Datebase of horses. Need to increase age column by a year, every year. Any
ideas??
 
V

Van T. Dinh

You should only store birth date, NOT the age and whenever you need the age,
work it out w.r.t. current date.
 
J

John Vinson

Datebase of horses. Need to increase age column by a year, every year. Any
ideas??
Click to expand...

Just store the birthdate; if the horse gets a year older on January 1,
just use a Query with a calculated field

DateDiff("yyyy", [Birthdate], Date())

to calculate it on the fly.

John W. Vinson[MVP]
(no longer chatting for now)
 
Top