select artist_id, artist_name, birth, death, fnAge([Birth], [Death]) As Age from yourTableName; Jqws13_ AFAIK, the simplest expression for calculating age in years to the current date is: FunctionAgeYears(DOBAsDate)AsIntegerAgeYears=DateDiff("yyyy",DOB,Date)+(Format(DOB,"mmdd")>Forma...
Given Kirk's birth date of January 15, 2233 (assuming his birth date in the alternate universe depicted in STAR TREK was the same as, or close to, his birth date in The Original Series), his exact age can now be calculated for any Stardate given in an episode of The Original Series...
fnAge = DateDiff("yyyy", dtmBD, dtmDate) + _(dtmDate < DateSerial(Year(dtmDate), Month(dtmBD), _Day(dtmBD)))End Functionyou create a Query against your table:select artist_id, artist_name, birth, death, fnAge([Birth], [Death]) As Age from yourTableName; Reply...
Hi All, Just got a question regarding calculating ages in tables in access. I am on Access 2016, and I have two columns, DOB, and Death Date. I only have one entry for a death date, and if there is not a death date I want to calculate it from today. Would I use a Calculated ...
fnAge = DateDiff(\"yyyy\", dtmBD, dtmDate) + _(dtmDate < DateSerial(Year(dtmDate), Month(dtmBD), _Day(dtmBD)))End Functionyou create a Query against your table:select artist_id, artist_name, birth, death, fnAge([Birth], [Death]) As Age from yourTableName;","author":{"__...