report fields

[Michael]

I have a report that pulls data from our tickets, clients, and
accounting table. Each of the tables is linked by the client id. If
I enter more than one rate item in the accounting table, my ticket
(work order) prints one page for every rate item. How can I set up
the report to print out one ticket and multiple rate items on the same
page?

 

[John W. Vinson]

I have a report that pulls data from our tickets, clients, and
accounting table. Each of the tables is linked by the client id. If
I enter more than one rate item in the accounting table, my ticket
(work order) prints one page for every rate item. How can I set up
the report to print out one ticket and multiple rate items on the same
page?

Use the report's Sorting and Grouping dialog to group by Ticket; put the
ticket-specific information in the group Header (or Footer, or both) and the
rate data in the Detail section.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Michael]

So simple. Thanks!