Question: what does it mean by totalrevenue structions Access 2019 PO Instructions Point Possi Create a copy of the Revenue and Cost by Country query named

what does it mean by totalrevenue

structions Access 2019 PO Instructions Point Possi Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and LastName fields. Move the Total Revenue field to the end. Rename the Total Revenue field to OrderTotal. Change the caption to Order Total. Add a new field using the Expression Builder named SamplePayment. Insert the Pmt function with the following parameters: Use .05/12 for the rate argument (5% interest, paid monthly) Use the number 12 for the num_periods argument (12 months) . Use the calculated field Order Total for the present_value Use 0 for both future_value and type Change the Total row to Expression for the Sample Payment field. Change the Format for the Sample Payment field to Currency. Run the query and verify the second order(with LastName Sparks) has a sample payment of $26.80. Note: it will display as a negative number. Save and

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 General Management Questions!

Selective perception occurs when We organize people into groups You base judgements on information that is easier to recall You only see what you want to see We believe others think and feel the same...

Points Step Instructions Possible 11 Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and...

how do i move the total revenue field to the end structions Access 2019 Poir Possi Instructions 5 5 Create a copy of the Revenue and Cost by Country query named Customer Payments Switch to Design...

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...

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...

"Customer Payments Query The CEO wants the salespeople to discuss financing with customers. In order to do so, she asked you to create a query showing the impact on price for prior orders. This way,...

Create a copy of the Revenue and Cost by Country query named Customer Payments. Switch to Design view of the new query and remove the Country, TotalCost, and OrderDate fields. Add the FirstName and...

Need ONLY an answer to Part C, step 1, questions 1 and 3. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most...

Exp19_Access_Ch02_Capstone - International Foodies 1.0 Project Description: International Foodies is an importer of exotic foods from all over the world. You landed a summer internship with the...

Only Need a the answer for STEP 1 of "PART C" Need a sample answer doesn't have to be extremely detailed or anything. Term Project Part A: Understanding Financial Statements Locate and use an annual...

The following transactions are for Blossom Company. 1. On December 3, Blossom Company sold $400,000 of merchandise to Crane Co. on account. The cost of the merchandise sold was $264,000. 2. On...

Two genes (A and B) control fruit color in pepper plants. The following genotypes and corresponding phenotypes are produced. DRAW the biochemical pathway used to produce fruit color in pepper plants....

Mike and Laura are retired and have $ 3 0 1 2 0 8 9 dollars in their retirement account. If they estimate their annual expenses at $ 9 8 0 2 0 , then how much should they allocate to stocks and bonds...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...