Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MS ACCESS Dates 2
- Thread starter CliffMull
- Start date
-
1
- #2
There's instructions for Age()-function in:<br>
<br>
Al
<br>
Al
-
1
- #3
add a text box to your form in the text box I use this calculation: =([date]-[dob])/365.25<br>
<br>
go to the properties for this field an add a"#" to the format.<br>
<br>
PS where date is in the formula enter the field that contains the date you want to check against.
<br>
go to the properties for this field an add a"#" to the format.<br>
<br>
PS where date is in the formula enter the field that contains the date you want to check against.
- Status