More query issues .....

[Guest]

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?

 

[Guest]

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?

 

[Guest]

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.