Reply to thread

Message: [QUOTE="tjenkins22, post: 11799590, member: 69386"] 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. [/QUOTE]