I have just made a simple query to calculate the age of patients from their D.O.B with the expression:
Age: ((Date()-[tbl Patients]![Date Of Birth])/365)
What do i have to do to remove the decimal places i cant figure how you do it.
I tried to change the number of decimal places to display in the form but its still doing it to like 9 places.
Cheers Andy.
Age: ((Date()-[tbl Patients]![Date Of Birth])/365)
What do i have to do to remove the decimal places i cant figure how you do it.
I tried to change the number of decimal places to display in the form but its still doing it to like 9 places.
Cheers Andy.
