Don't show duplicates in report 1

[cutestuff]

Is this possible?

The report currently looks like this:
Col1 Col2 Col3
1 ABC 123
1 ABC 456
1 ABC 123
1 DEF 123

I would like to remove the duplicates so the report looks like:
Col1 Col2 Col3
1 ABC 123
DEF 456
So basically group it by Col1 and then just show unique items for Col2 and Col3.

But I am getting this:
Col1 Col2 Col3
1 ABC 123
ABC 456
DEF 123

I just want ABC to show up once and 123 to show up once since since they are grouped by Col1. I tried the 'hide duplicates' in the report but it keeps leaving blanks everywhere.

Is this possible? Or is there a way around this?

thanks in advance,
j

 

[dhookom]

I assume you have a couple tables related to a main table but no relationship to each other.

You could create a main report based on Col1 unique values and then a couple subreport based on unique combinations of Col1 & Col2 and Col1 & Col3.

Duane
Hook'D on Access
MS Access MVP

 

[cutestuff]

They are related only through column 1.
I am trying the subreport but it's taking an awful long time to format the page (I am using Access 2003 - don't know if that makes a difference). Is that normal?

 

[cutestuff]

Subreport worked! I just have to play around with the margins.
Thank you so much! Appreciate it!

 

[cutestuff]

sorry for asking late but is there a way to make it run faster? it works if i just choose 2 or 3 items but if i want all it takes a long time to format (5minutes+). how can i get around that?

thanks so much,
j

 

[dhookom]

How about providing some information about table structures, indexes, number of records, link master/child of the subreports?

Do you have any Page of Pages in the report?

Duane
Hook'D on Access
MS Access MVP

 

[cutestuff]

Yes, the report is several pages long.
I basically have 5 small tables (it comes in from a different source so it has to be in different tables). I use one main query to link the 5 tables together (they have a common itemID but that's all that's the same). Then I feed this query into the report. Sounds simple enough huh? In the report I have around 5 fields from the query and 2 subreports that I am trying to display as normal fields. These 2 subreports are so that the duplicates don't show. That works good now (thanks for the advice . I just wanted to know if it is possible to speed the report generation up. If I want to view all there are around 500+ pages so that might be the normal running time for the report? It keeps saying "formatting pages". If I select one item at a item it works good.

 

[cutestuff]

hi duane,
i've figured it out. it seems like it's running the queries for every time every page opens. i tested it and turned the queries into tables and fed it into the report and it opened within seconds.
thank you so much though for your help.
jen