ok, Here is my problem. I want to be able to calculate the number of days between deliveries on my subform.
The fields are:
InvoiceID, Winter/Summer, DateOfDelivery, GallonsDelivered, PriceperGallon, RateStatus, Driver, Remarks.
The final result i'm trying to achieve is to have a text box that will calculate the "daily avg usage rate" based on the DateDiff of the current record "DateOfDelivery" and the previous record "DateOfDelivery" which will give me #Days between deliveries. Then I will divide GallonsDelivered by #Days for the "Daily Avg Usage Rate". My problem is I dont know how to use recordset clone or FindPrevious VBA. I looked in help but i'm not understanding how to do it. Any help would be appreciated. If anyone wants to take on the challange of doing it, I can email the program to you so you can take a look at it....Thanks
Alan
The fields are:
InvoiceID, Winter/Summer, DateOfDelivery, GallonsDelivered, PriceperGallon, RateStatus, Driver, Remarks.
The final result i'm trying to achieve is to have a text box that will calculate the "daily avg usage rate" based on the DateDiff of the current record "DateOfDelivery" and the previous record "DateOfDelivery" which will give me #Days between deliveries. Then I will divide GallonsDelivered by #Days for the "Daily Avg Usage Rate". My problem is I dont know how to use recordset clone or FindPrevious VBA. I looked in help but i'm not understanding how to do it. Any help would be appreciated. If anyone wants to take on the challange of doing it, I can email the program to you so you can take a look at it....Thanks
Alan
