Hello,
In my database I have three fields - Arrival and Departure date, which I manually populate - and price. I have a different db which details the price according to a date range. For instance between 01/May/05 and 01/June/05 the price is 230.
What I want to be able to do is to have the price in my first db to populate based upon the arrival and departure dates that I enter.
I hope this is clear and that someone can help me.
Thanks,
Iain.
In my database I have three fields - Arrival and Departure date, which I manually populate - and price. I have a different db which details the price according to a date range. For instance between 01/May/05 and 01/June/05 the price is 230.
What I want to be able to do is to have the price in my first db to populate based upon the arrival and departure dates that I enter.
I hope this is clear and that someone can help me.
Thanks,
Iain.