The report I'm working on is a form letter that pulls data from two tables. One table has the basic client data and the other the accounts receivable data. However, I am trying to make the report pull the client information once and have a calculation with the total amount due. The report right now is showing each instance of the amounts due or payments made. How can I summarize the accounts receivable data so that each client just shows one page with the net accounts receivable amount due?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping records in form letter
- Thread starter JuanRa
- Start date
In the detail section, put the field(s) for amount due or payments made.
Group by client.
In the client group footer, put your name, address, letter, and a group total of the field(s) for amount due or payments made.
Suppress all but the group footer.
Group by client.
In the client group footer, put your name, address, letter, and a group total of the field(s) for amount due or payments made.
Suppress all but the group footer.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question