Guest SQL question Posted February 6, 2006 Share Posted February 6, 2006 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 More sharing options...
pulpfiction Posted February 6, 2006 Share Posted February 6, 2006 Do you want to calculate the age? Thencheck out this linkhttp://w3schools.invisionzone.com/index.php?showtopic=2038 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now