This is one of my questions in Microsoft Access

Use the data in tblReservations and tblRoomCharges to create a query that calculates the

attendants gratuity on a room service order (18%) or spa treatment (25%). Your query

results should display ReservationID, CheckInDate, ChargeCategory, ChargeAmount, and a

calculated field named Gratuity in that order. If the ChargeCategory is not a spa treatment or

room service, a zero should be displayed in the field.

te Insert Rows . Insert Columns FProperty Sheet nion ?Table Names ass-Through x Delete Rows Delete Columns Show Totals Parameters ata Definition Table Builder Return: All Query Setup Show/Hide ips tbiReservations tblRoomCharges Guestlo CheckinDate NightsStay NumberOfGuests Crib Room Charger) GuestiD ReservationiD ChargeCategory ChargeAmount RoomType RoomType.Value DiscountType