This is in Microsoft Access.

Use the data in tblReservations, tblPayments, and qryTotalRoomCharges to create a query to

see what the total charges will be for each guest. Your query results should display

ReservationID, CheckInDate, NightsStay, RoomRate, and TotalRoomCharges from

qryTotalRoomCharges, PmtAmount from tblPayments, and DiscountType from tblReservations.

Create a new field named AmountDue that calculates whether an amount is due. (Hint: If

the total room charges are more than the payment amount, then the guest owes money.)

Create a new field named RefundDue that calculates whether a refund is owed to a guest.