Adding days

[ptrifile]

I am using a report to get the last order date:

=Max([date_ordered])

and then average number of days between orders:

=DateDiff("d",Min([Date_ordered]),Max([date_ordered]))/Count([itemnumber])

I would now like to have another Text Box that will give me when the estimated next order date is by adding the number of average days between orders to the last order date. I cant seem to get it right....any suggestions?

Thanks!

Paul

 

[genomon]

TextBox = DateAdd("d", AverageDays, Max([date_ordered]))
ought to do the trick......