Report showing extra data

[Guest]

I created a report, and chose Yes for Hide Duplicates on my data. However,
it is showing two additional pages with duplicates of the data in the report.
Why would it do that and how can I stop it?

 

[Allen Browne]

The Hide Duplicates property of a text box does not suppress the printing of
duplicate records. All it does is leave white space on the next row of the
report if that text box had the same value as on the previous row.

If you are getting multiple copies of the data, you need to look at the
query (or table) that is the Record Source for your report. If you want to
suppress the duplicates, you need to modify the query, such as making it a
Totals query (Total on View menu in query design), or setting the Unique
Values property to Yes (in the Properties box in query design.)

Or, you may need to change the structure of your report so that some of the
fields are placed in a Group Header or Group Footer where they appear one as
a heading over all the records that are printed in the Detail section.
(Choose Sorting And Grouping on the View menu in report design.)

 

[Guest]

That is good information, Allen, thank you.

However, it isn't helping what I need. Maybe this information will make
things different. In my table, several tables have combo boxes as the Row
Source Types. These are the fields that I am trying to refer to in a report.
In the report, I have created fields that look up the fields and how many
come back "Pass" and how many come back "Fail" and so forth. Is there any
way to view this without getting several pages of the response?

 

[Allen Browne]

So you want a count of each value of each lookup field?

You could do that with a series of subreports.

1. Create a query into this table.

2. Depress the Totals button on the toolbar (upper Sigma icon.)
Access adds a Total row to the grid.

3. Drag the Pass/Fail field into the grid.
Accept Group By in the Total row under this field.

4. Drag the primary key field into the grid.
Choose Count in the Total row under this field.

5. Save the query, and use it as the RecordSource for your subreport.

6. Repeat the process for the other lookup fields.

The end result will be a main report that lists each of the options for each
of the lookup fields, with the count beside each one.