Total charge , creating a query

[lasts3cond]

Im completely new to access and stuck on this problem. I must create a query that calculates a total room charge for a guest. My query results needs to list Guestname, ReseversatonID, Checkindate, Nightsstay, Roomrate, discounttype and totalroomcharges. Totalroomcharge is a calculated field . I must also subtract any discounts from the total charge . So far I have created a simple query and added all the required things that needs to be listed. But in design mode , I have no idea how to get started with this.

[June7]

Without know your db structure, can't be specific. In general, options are:

1. aggregate Totals (Group By) query

2. report using Grouping & Sorting features with aggregate calcs in group footer