adding days to a date based on calculation result

[manuellh]

hey, so here's the deal. I'm working on a database for a rooming house, I'm trying to devide the 'payment' by the 'daily rate' to get the number of days the tenant will be paid through, so I need to ad the resulting number to the paid through' date field. I have no clue how to go about this. I just grabbed this from some other thread, and think it could be modified for the last part of my script.

Date(Month(DD Start Date); Day(DD Start Date)+ RESULTS; Year(DD Start Date))

any help would be greatly appreciated.

Thanks,

Manuel

[systwo]

I am not sure I completely understand what you are asking as it should be very simple.

The payment divided by the rate will determine the number of days paid for. Just add these days to the date through field as a straight calculation.

if DateThroughField = 01/01/08 and the number of days is 10 (Result) the calculation (DateThroughField + Result) would be 11/01/08. You may need to deal with any fractions either rounding up or down as required.

If I have misunderstood please supply more information and I will try to help.