I am trying to calculate the expiration date for automatically renewing
contracts. I want the final form to calculate the current expiration date
by
calculating renewal periods but just showing the final one. The contract
is
first signed for a 12, 18, or 24 month period while the renewal period is
usually for 12 months. This is the table:
Tbl: Agreement
ID
Date Signed
First Term
Subsequent Period Term
I got this far in my query and I want to know if I am going along the
right
path or if I should go about my goal some other way
SELECT [Supplier Agreement].[Vendor ID], [Supplier Agreement].[Contract
Signed], DateAdd("m",[Contract Signed],[Primary Term of Contract]) AS [End
of
First Period], [Supplier Agreement].[Primary Term of Contract]
FROM [Supplier Agreement];
Thank you for your help,
|
