Date Calculations field

Mar 5, 2008
Reaction score
I am trying to build an access table for our leasing information. I know i will have to use a query to create the calculated date but i am not sure how to go about the coding. here is what i am looking at.

Table columns
CommencementDate date/time
Terms number

I want to create two on the fly fields named begindate and enddate that will look at the terms and calculate the future dates from the commencementdate. for example if i lease a system on 20-sep-2006 with 24 months terms i know my end of lease is 20-sep-2008. i have between 90 and 180 days before this to decide if i want to extend the lease or upgrade. I need to be able to create a report that will show this time frame for example

commencementdate = 20-sep-2006
terms = 24
begindate = 20-mar-2008
enddate = 20-jun-2008

the only problem that i have is my terms is a variable number. it will be either 24, 36, 48. any help on this would be great.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question