- Joined
- Mar 5, 2008
- Messages
- 1
- Reaction score
- 0
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.
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.