Question: 12. Open the qryClientBilling query in Design View and update it as described below: a. Add a calculated field with the title SessionCost to the

12. Open the qryClientBilling query in Design View and update it as described below:

a. Add a calculated field with the title SessionCost to the end of the query that calculates the cost per session. The formula will calculate the Amount field value divided by the Sessions field value. (Hint: The division symbol is the / symbol.)

b. Use Cost per Session for the calculated fields caption property.

c. Format the SessionCost field as currency.

d. Move the SessionCost field to the left of the FirstName field.

e. Sort the records first in descending order by the SessionCost field values, and then in ascending order by the LastName field values.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!