Duplicate Data Lines Printing

  • Thread starter Thread starter Biker2
  • Start date Start date
B

Biker2

I have a report that is printing out multiple lines of the
same data. The query it is based on has the multiple lines
in the table. How do I get only the first occurence of a
line to print and not all occurences?
 
Change the underlying query to a TOTALS query

VIEW TOTAL on menu bar -

this will give you only one occurance of every similar record.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Blank Lines to a Report 0
Print Bug-Possible to Print Preview by default Mult-page or 2-page 1
Access Sorting and grouping using multiple tables 0
Report printing multiple pages based on query 2
Cancel printing blank lines 1
Formatting Data 1
Print Report If Sub-Report Has Data 2
how to put multiple results in one text box 2

Back
Top