Calculate price

[Hill Billy]

Hi!

I have a problem with calculating the price for a reservation.

In my main table I have two date fields: day of arrival and day of departure

In the price table I have a lot of post with different prices that changes over the seasons.

Now, I want to calculate the total price in my main table. Let

[-Queue-]

I would loop through the related periods and set the total price incrementally, based on the number of days falling into each period.

For more specific assistance, you can zip/stuff your file and attach it here.