I am working on a rental system where products are booked out at different rates depending on the calendar, which has no obvious start or end point. I have a rates file which contains the product ID, start date, end date and the rental value. These should not overlap for any one product, and there will always be at least one rate for each product. In a related file I'd like to be able to enter a start date and always return a rate. This rate should be either the rate for that product with the start date closest but less than my desired start date or, the earliest start rate if my start date was before the start date of the earliest rate.

I've looked at Mikhail Edoshin's Smart Ranges and R J Cologon's Range Maker, but can't see how to make them return a default value in the way described above. Has anyone found a solution for this?

Thanks

Brian

Have managed to solve this problem now, using Mikhail Edoshins Smart Ranges techniques. If anyone needs the solution, let me know.

Hi Brian,

The Smart Ranges Techniques is a very difficult one to understand. I for one would like to see you post your file(s) to the Sample Files of this Forum with a description of what it does.

TIA

Lee