I have a report set up with text boxes to display data from records. Currently it will display data for each record in the query. How can I get it to display in the footer multiple dates amounts due amounts paid and amounts owed for the same person? If needed I can supply the query if that is where the problem lies.