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

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:

1. Open your report in Design View: To do this, right-click on the report in the Navigation Pane and select "Design View".

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

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

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

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

6. 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]).

7. Format the text box as currency: Still in the Property Sheet, go to the "Format" tab and set the Format property to "Currency".

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