Příklad SQL dotazu pro MS Access:
SELECT datum_narozeni, DateDiff("yyyy", datum_narozeni, Date()) - Iif(Month(Date()) * 100 + Day(Date()) > Month(datum_narozeni) * 100 + Day(datum_narozeni), 0, 1) AS vek FROM...
Příklad SQL dotazu pro MS Access:
SELECT datum_narozeni, DateDiff("yyyy", datum_narozeni, Date()) - Iif(Month(Date()) * 100 + Day(Date()) > Month(datum_narozeni) * 100 + Day(datum_narozeni), 0, 1) AS vek FROM...