MS ACCESS で年齢を求める
SELECT IIf(Format([生年月日], "mm/dd") > Format(Date(), "mm/dd"), DateDiff("yyyy", [生年月日], Date())-1, DateDiff("yyyy", [生年月日], Date()) ) AS 年齢;
SELECT IIf(Format([生年月日], "mm/dd") > Format(Date(), "mm/dd"), DateDiff("yyyy", [生年月日], Date())-1, DateDiff("yyyy", [生年月日], Date()) ) AS 年齢;