"Hide Duplicates" Not Hiding Duplicates

[jaaret]

I haven't been able to figure out why an item is displaying multiple times in the detail section even though I have Hide Duplicates set to Yes. Is there something else that overrides the Hide Duplicates control?

 

[dhookom]

What results are you seeing in your report? I think you might have a misconception of what Hide Duplicates does but we can't tell without more information from you.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jaaret]

For simplicity, let's say my report has two fields in the detail section: txtAgendaItem and txtMinutes. If there are three Minutes records for one Agenda Item record I only want the Agenda Item to display once with the first Minutes detail but not display for the other two. Even with Hide Duplicates set to Yes the identical Agenda Item is displaying with each Minutes record in the detail.

Thanks in advance,
Jaaret

 

[dhookom]

Are your controls both text boxes? Do they display on the same page? Are they displayed/printed in txtAgendaItem order?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jaaret]

Both txtAgendaItem and txtMinutes are text boxes that dispay on the same page. If they are both in the detail section they both display for every record. My workaround has been to move txtAgendaItem into the AgendaSequence Group Header. It displays only once but is offset from the minutes. My preference is to have both fields in the detail so they are horizontally aligned (this matches the legacy format in a Word template) but to have txtAgenaItem display once with multiple meeting minutes.

Thanks for working with me on this,
Jaaret

 

[dhookom]

I still don't understand why Hide Duplicates doesn't work. However, consider adding a new group by level on txtAgendaItem and display the Group Header section.
Add a text box to the txtAgendaItem Group Header and set its height to display just the text box. Add code to the On Format event of the txtAgendaItem group header section:

   Me.MoveLayout = False

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lespaul]

I still don't understand why Hide Duplicates doesn't work.

If there are three Minutes records for one Agenda Item record I only want the Agenda Item to display once with the first Minutes detail but not display for the other two. Even with Hide Duplicates set to Yes the identical Agenda Item is displaying with each Minutes record in the detail.

Does each Minutes have a different value?

Agenda Item Minutes
1 10
1 12
1 15

Duane, is the 'Hide Duplicates' Access' term for SELECT DISTINCT? Or is it different setting in the reports? Does it work differently?

The above would be the records returned in a SELECT DISTINCT query....

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[dhookom]

Assuming we create a query in Northwind that select records from the orders and order details tables. Then create a report from this and set the primary sorting and grouping to OrderID and don't display any header or footer sections.

Add OrderID, OrderDate, ProductID, and Quantity to the detail section of the report as Text Boxes. Set the Hide Duplicates property of OrderID to Yes. This would only display something like this:

10248  04-Jul-1996   Queso Cabrales                   12
       04-Jul-1996   Singaporean Hokkien Fried Mee    10
       04-Jul-1996   Mozzarella di Giovanni            5
10249  05-Jul-1996   Tofu                              9
       05-Jul-1996   Manjimup Dried Apples            40
10250  08-Jul-1996   Jack's New England Clam Chowder  10
       08-Jul-1996   Manjimup Dried Apples            35
       08-Jul-1996   Louisiana Fiery Hot Pepper Sauce 15

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]