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: On the Design tab, 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". Select the field you want to group by, in this case, it would be 'Movie'.

4. Add a footer: Once the group is created, you will see an option for "with a footer section". Click on "with a footer section" to add a footer to the group.

5. Add a text box to the footer: Go to the Design tab, in the Controls group, click on Text Box and draw it into the footer section.

6. Set the Control Source of the text box: Right-click on the text box and select "Properties". In the Control Source property, type "=Sum([Paid Amount])". This will calculate the total of the Paid Amount for each group.

7. Format the text box as Currency: In the Format property of the text box, type "Currency". This will display the total in the currency format.

8. Save and run your report: You should now see the total of Paid Amount for each Movie in the currency format in the footer of each group.