Good morning. I am trying to figure out how to calculate 5 years from a LoanOriginalDate to the LoanEndingDate in a query. It is so I will be able to release 5 year forgivable loans. Please advise and thank you so much!
Novice
Windows Vista 
Access 2007
Good morning. I am trying to figure out how to calculate 5 years from a LoanOriginalDate to the LoanEndingDate in a query. It is so I will be able to release 5 year forgivable loans. Please advise and thank you so much!
Access Developer
Windows XP Access 2003
The LoanEndingDate should be calculated using the DateAdd() funtion. You can find the syntax for it in the Access Help files.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
Calculation Field in table vs Query calculation
Query to search for Certain Years
Posting Permissions
Reply With Quote