Jump to content

Calculated an age of an person

Guest SQL question

Recommended Posts

Guest SQL question

I have an question of school to make an in msacces an table where the age is calculated.SELECT VERPLEEG.NAAM, VERPLEEG.GEBDATUM, VERPLEEG.LEEFTIJDFROM VERPLEEGAnd then ?verpleeg =nurse tablenaam = naam of the nursegebdatum = date of bornleeftijd = ageSomething of WHERE (DATEDIFF('D',GEBDATUM,NOW())/365.25);It did not work.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...