Hi, haven’t a scooby what to do with this one. I have a database which I have recently set up to calculate the package price for a holiday with flights leaving on one date and returning on another, dependant upon hotel prices for adults/children etc. This is done entirely on calculated form objects accessing data in combo boxes.
The users like this, and the problem is they now want a report which will select the best combination of hotel price/flight price for a certain hotel/departure/arrival airport between selected dates, with a flexible duration of between 1-14 days. I have a query which shows the total hotel cost for the number of adult/children for each individual date between the date parameters (possible depart dates v. possible return dates matching the duration). I also have another query which takes the same date parameters and shows where there are corresponding out and return flights, and how much the total cost of flights would be.
What I need to do is somehow sum the total hotel price between potential departure/return dates in the second query…… anybody done anything like this before??? 
