Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access
Resolved · Low Priority · Version 2003
Reply Mon 2 Mar 2009, 15:55Delegate Stephanie said...
Stephanie has attended:
Excel Intermediate course
Access Introduction course
Access
How to date diff with a date of birth to calculate the age of the person on a certain future date.
For upcoming training course dates see: Pricing & availability
RE: Access
Hello Stephanie
Thank you for your question
If you have the two dates stored in two seperate fields I would create a simple query and use the following:
Expr1: Dates!Date2-Dates!Date1
This will give you the number of days. (In this example I have created a table called Dates with two fields, Date2 holding the later date and Date1 holding the earlier date.)
If you wanted the result in years you could use this and just format the query result field accordingly:
Expr1: ([Dates]![Date2]-[Dates]![Date1])/365
You can also use DATEDIFF formula which is explained in more detail on this link:
http://office.microsoft.com/en-us/access/HP010984861033.aspx
If this resolves your question, please mark it as resolved. If not, please reply with more information.
Kind regards
Cress
Tue 10 Mar 2009: Automatically marked as resolved.
|