>Okay. Here's what I'm really trying to do. I want to take a table that is up to 10 records and evenly distribute time between records. The time will be in 1/4 hour increments (0.25, 0.50, 0.75, 1.00, 1.25...) and 0.25 is the smallest. The total for the records must equal the starting "quarter-hour" amount. So I can't just have the last record hold the remainder, I need to switch from 0.02 in each record to 0.03 at some point I determine programmatically.
What do you mean by "up to 10 records"? If there are 7 records, what is the distribution?