Hi there,

I have an access form that is used for cash-ups. The cash-ups are not done on a regular basis and the owner requested that the database look at the last cash-up date, current cash-up date and calculate the difference in days and then the average per day taken from the total cash-up figure. This was simple and is done however, what he now wants is to export this data to Excel and have Excel split the one record by the average number of days and reflect the average amount over as many lines.

Eg: R5,000.00 / 20 days = R250.00 per day.

This data needs to be imported into Excel (taken from THREE Access fields) and displayed in TWENTY lines each with a value of R250.00.

I hope that I've been clear enough and thanks in advance for any help.