I got stuck and do not know what to do can I please have each step on how to do this calculation please thnak you Use th

[answerhappygod]

I got stuck and do not know what to do can I please have each
step on how to do this calculation please thnak you
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.

I Got Stuck And Do Not Know What To Do Can I Please Have Each Step On How To Do This Calculation Please Thnak You Use Th 1 (94.49 KiB) Viewed 85 times

File Home Create External Data Database Tools Design Tell me what you want to do... i +! ! Union k Σ FE XYZ Property Sheet Table Names Insert Rows 1 Insert Columns Delete Rows Delete Columns Builder m Return: All Run Pass-Through Data Definition Select Make Append Update Crosstab Delete Table View Totals Parameters Show Table Results Query Type Query Setup Show/Hide « 2 tblPayments Relationships Query1 All Access Obje... Search... Tables tblReservations 스 tblRoomCharges 3 thicharge Details ? RoomChargeID E tblGuests ReservationID Guest CheckinDate NightsStay NumberOfGuests Crib Handicapped Room Type RoomType.Value Room Rate DiscountType GuestID ReservationID ChargeCategory Charge Amount mSysRowld tblPayments e F tb Reservations 1 tbl RoomCharges Queries Field: Checkin Date Table: tbl Reservations Total Group By Sort: Show Criteria: or: ChargeCategory tbl RoomCharges Count Ascending ChargeAmount tbl RoomCharges Count Ascending Expr1: [grutuity tblRoomCharges Group By Ascending Query1 n D "Room Service" SPA Treatment