Hiding Duplicates

[macarch]

I am creating a report from a table listing Client names under particular
project types. I have different projects from the same Client under one
project type, thus I want to hide the duplicate Client names. When I choose
the HIDE DUPLICATES option from the properties menu, it does hide the
duplicate Client names, but it leaves a blank where the duplicate name would
have been in the report. The report now has all of these blanks spots. I
have tried the CAN SHRINK option, but that doesn't seem to work. What am I
missing or doing wrong?
Thanks

 

[Duane Hookom]

It isn't clear what you expect to happen or how your report is structured. It
really sounds like you should create a group header on Client Name and only
display the Client Name in this header section.

 

[macarch]

Duane, the report is structured with a project type group header and the
client names in the detail area below the header. What I want is something
like this:

FINANCIAL:
Chase Bank
CitiBank
Bank One
BankFinancial
etc.

FAST FOOD SERVICE:
McDonalds
Burger King
Taco Bell
Wendy's
etc.

But when I remove the duplicate Client Names I get something like this:

FINANCIAL:
Chase Bank

CitiBank

Bank One
BankFinancial
etc.

FAST FOOD SERVICE:
McDonalds

Burger King
Taco Bell

Wendy's
etc.

I am trying to get the Client names to be listed without blank spaces where
a duplicate client name would have occured.

 

[Duane Hookom]

Did you try move the client names to a group header like I suggested and
remove them from the detail section?

Are there details for each client that you want to display?

 

[macarch]

Duane, yes, I tried what you suggested and the result looked like this:

FINANCIAL:
Chase Bank

FAST FOOD SERVICE:
McDonalds

It only displayed the first Client name in each project type catagory.

There are no other details needed to be displayed. I am just looking to
create a report showing who our clients are for the various types of projects
we do. This is why I want to hide the duplicate client names. I don't want
to list Chase Bank multiple times under the Finanaical project type catagory
even though we have done multiple projects for Chase Bank; listing them just
once will be adequate.

 

[Duane Hookom]

Then why not change your report's record source to a totals query that
doesn't include in details like individual projects. Otherwise leave the
details of projects in but hide the detail section.

 

[macarch]

Duane, that did it. I changed the record source of the report to a query
only containing the project type and the client names, and the blank spaces
went away.
Thanks for your help.

 

[Cummings]

Macarch --

I've been trying to do the same for 2 weeks. I'm obviously ignorant.

Can you walk me through what you did? I did a query with just the two
fields, but how did you get the report to ignore duplicates?

Thanks

 

[Duane Hookom]

I expect he clicked on the View->Totals menu in query design or the sigma
button. This should allow you to specify "Group By" on fields you want each
value displayed. Don't include fields that you don't want to display every
value unless you are aggregating them with Sum, Count, Min, Max, ...

 

[Cummings]

Thank you. Worked fine.

jim
--
JP Cummings

I expect he clicked on the View->Totals menu in query design or the sigma
button. This should allow you to specify "Group By" on fields you want each
value displayed. Don't include fields that you don't want to display every
value unless you are aggregating them with Sum, Count, Min, Max, ...

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm