Report Printing 6 copies

[coolcatkelso]

Hiya

I have a report Called Working Schedule

The basis off the report is - a report detailing what my men have done at the job, IE a Diary of work done.

Layout is in a datasheet view

When I click print report its printing out every entry for this diary, however, each entry is showing the same info

I just need it to print out one entry.

The attached pic should be able to explain better

Each line on the datasheet, is being printed out as aposed to just one table, so really, I have six lines in the datasheet, and I'm getting tables of the same info on the report

Cheers

CCK

Access 2007
________
MARYSVILLE COLLECTIVE SOLUTION DISPENSARY

 

[genomon]

You get six because that is how many records are returned by the recordsource. If the records truly are duplicates, then this, from Access help, may be of use:

Hide duplicate data in a report

You can hide duplicate data on a report with sorted records or on a report with grouped records.
Hide duplicate data on a report with only sorted records

1. Create a report that sorts records on one or more fields that might contain duplicate values. How?
2. In report Design view, place the text boxes for all the fields in the detail section.
3. To display the property sheet for a text box that contains data that might repeat, make sure the text box is selected, and then click Properties on the toolbar.
4. Set the HideDuplicates property to Yes. Note In any text boxes for which HideDuplicates is set to Yes, Microsoft Access prints a value in the first record in which that value occurs and, if records with the duplicate value continue onto another page, at the top of a new page.

Hide duplicate data on a report with grouped records

1. Create a report with one or more group levels. How?
2. In report Design view, move the text box for the field you're grouping on from the group header to the detail section.
3. To display the text box's property sheet, make sure the text box is selected, and then click Properties on the toolbar.
4. Set the HideDuplicates property to Yes.
5. Remove lines and all other controls from the group header.
6. Double-click the section selector of the group header to display its property sheet.
7. Set the Height property of the group header to 0. Note The group name will appear only at the beginning of a new group or at the top of a new page if the group continues for more than one page.