report fields

  • Thread starter Thread starter Michael
  • Start date Start date
M

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?
 
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?
Click to expand...

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
 
Back
Top