More query issues .....

Y

yakdog

Two tables--Rooms and Reservations. The Rooms table has a room number field
with repeating numbers. How do I consolidate those in the query, and
determine the income generated based upon the check-in and check-out dates?
 
K

KARL DEWEY

The Rooms table has a room number field with repeating numbers.
What does this mean? Do you have a spreadsheet?
What fields does your Reservations table have?
 
Y

yakdog

It's a Bed and Breakfast. These are two Access Tables in a query. No
spreadsheet. The Reservations table has room numbers (some of which repeat
because different customer rent the room during different time periods),
customer numbers, check-in and check-out dates. The Rooms table has Room
number, floor number, Price per night fields. The calculated field is
Total:([Rooms].[PricePerNight])*([Reservation].[Check-outDate]-[Reservations].[Check-inDate]).
I have, for example, three reservations for room 4. How do I combine those
into one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top