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
Get step-by-step solutions from verified subject matter experts
