Split one record into multiple lines

[Sally]

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 calculate the average take per day by dividing the total take for the period by the number of days from the last cash-up date to the current cash-up date. This was simple and is done however, what he now wants is to export this data to another table and have it split the total amount per record by the average number of days and reflect the average amount per day over as many lines.

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

This data needs to be displayed in TWENTY lines each with a value of R250.00.

Is this possible please?

Thank you.

[June7]

This will require VBA programming.