Question: In Access, In the query, add a calculated field to the SELECT clause that multiplies the Rate and Hours fields from the HourlyFees table. Set

In Access, In the query, add a calculated field to the SELECT clause that multiplies the Rate and Hours fields from the HourlyFees table. Set the caption for the calculated field as Total. Add a SQL aggregate function to the calculated field to calculate the total of the Rate field multiplied by the Hours field.

here is what I have and it is telling me I am missing the last sentence in the question.

SELECT Lawyers.FName, Lawyers.LName, Sum([HourlyFees]![Rate]*[HourlyFees]![Hours]) AS Total

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 Databases Questions!

Floyd's Bumpers has distribution centers in Lafayette, Indiana; Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania. Each distribution center carries all...

Access Project if anyone can complete by 8/1/2018 and return completed file it would be a huge help YO16_AC_COMP_GRADER_CAP_AS - Twilight Resort and Spa Database Project Description: The Twilight...

Access Exam Fall 2 0 2 4 : Landscaping Description Properly name your tables Customers and Landscapers 1 ) . Customers table. 2 ) . Landscapers table. 2 . Database Application Requirement: Using...

please help 1 N 2 3 4 5 6 7 Start Access. Open the downloaded Access file named Exp19_Access_Ch03_Cap_Brilton_Madley_Games.accdb. Grader has automatically added your last name to the beginning of the...

GoGopher! Amol Mehta, a recent college graduate living in Boulder, Colorado, spent months earning money by running errands and completing basic chores for family members and acquaintances, while...

Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named Exp19_Access_Ch03_Cap_Brilton_Madley_Games.accdb . Grader has automatically added your last name to the...

Can you tell me the steps how to do it. Step Instructions Points Possible 1 Start Access. Open the file named Student_Access___ _O_Bonuses.accob downloaded with this project. 0 2 Set the Application...

Hi, I need assistance with this Access homework. The one already posted is missing steps. Project Description: Northwind Traders, an international gourmet food distributor, hired a new CEO. She asked...

Step Instructions 1 Start Access. Open the downloaded Access file named exploring_a03_Grader_h1 . 2 Create a query using Query Design. From the Customers table, include the fields CompanyName,...

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Access. Open the downloaded Access file named...

Refer to Polaris 2011 balance sheet in Appendix A. How many shares of common stock are authorized? How many shares of voting common stock are issued?

On November 1, Year 1, Farley Corporation sells receivables due in six months with a carrying amount of $100,000 to Town Square Bank for a cash payment of $95,000, subject to full recourse. Under the...

10. When an inverse relationship is graphed, the resulting line or curve is a. horizontal. b. vertical. c. upward sloping. d. downward sloping.

Based on the information below, please answer the following questions, answer should be strictly based on the stated information: Sample Scholarship Letter: Dear Ms. John, I am writing this on behalf...

(Appendices) What kind of account is allowance for uncollectible accounts? What does it represent? LO86

(Appendices) How do the periodic and perpetual inventory accounting systems differ from each other? LO64

(Appendices) Write the formulas for the calculation of accounts receivable turnover and inventory turnover. What do these calculations tell us about accounts receivable and inventory? LO53