Include a Group Footer that displays the ‘Total of Paid Amount’ for EACH ‘Movie’ in theCurrency format. HINT: you may want to use the Group & Sort Tool
Question
Include a Group Footer that displays the ‘Total of Paid Amount’ for EACH ‘Movie’ in the Currency format.
HINT: You may want to use the Group & Sort Tool.
Solution
It seems like you're asking for instructions on how to include a group footer in a report that displays the total of paid amount for each movie in a currency format. Here's how you can do this in Microsoft Access:
-
Open your report in Design View: To do this, right-click on the report in the Navigation Pane and select "Design View".
-
Open the Group, Sort, and Total pane: If it's not already open, you can do this by going to the "Design" tab on the Ribbon, then in the "Grouping & Totals" group, click on "Group & Sort".
-
Add a group: In the Group, Sort, and Total pane, click on "Add a group". You will then need to select the field you want to group by, which in this case is 'Movie'.
-
Add a footer: Once you've added the group, click on "More" in the Group, Sort, and Total pane to expand the options. Then, check the box for "with a footer section".
-
Add a text box to the footer: Go to the "Design" tab on the Ribbon, then in the "Controls" group, click on "Text Box" and draw it in the footer section you just added.
-
Set the Control Source of the text box: Right-click on the text box you just added, select "Properties", and in the "Data" tab of the Property Sheet, set the Control Source to be the sum of the 'Paid Amount' field. It should look something like this:
=Sum([Paid Amount])
. -
Format the text box as currency: Still in the Property Sheet, go to the "Format" tab and set the Format property to "Currency".
-
Save and view your report: You should now see a total of the 'Paid Amount' for each 'Movie' in the footer of each group, formatted as currency.
Remember, these instructions are for Microsoft Access. If you're using a different database or reporting tool, the steps may be different.
Similar Questions
Write a query to find the total amount you spent in each category (Groceries, Entertainment, etc.).
A famous actress made two movies last year. She was paid $182 403.00 for the first movie and $820 037.00 for the second. How much money did she earn last year?
One thousand rupees ..............(is/are) the price of a movie in a good theatre.a.None of the aboveb.Any of the abovec.Isd.Are
An actor's negotiated salary for a film would be a below the line cost.Group of answer choicesTrueFalse
An actor's negotiated salary for a film would be a below the line cost.Group of answer choicesTrueFals
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.