Accurately Calculating Age Form

Instructions and help about Accurately Calculating Age

to calculate the age in years calculate the difference between today's date and date of birth on the create tab in the queries group click on query design add the employees table add employee id first name last name and date of birth in the query design grid in the field row right click an empty column and then click on zoom in the shortcut menu to calculate the difference between today's date and date of birth use this expression click on ok run the query the query returns the number of days between the two dates and not the number of years switch back to design view and divide by 365 365.5 use parentheses to avoid errors due to order of operator precedence click on ok run the query now the query returns number of years decimal values are returned use the int function to remove the fractional portion run the query the int function doesn't round the ear up or down it merely removes the decimal part you can use the round function to round the number of years now the year is rounded to t