RE: Hiding Duplicates

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.

"Duane Hookom" wrote:

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.

--
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


"macarch" wrote:

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" wrote:

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?

--
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


"macarch" wrote:

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" wrote:

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.

--
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


"macarch" wrote:

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

.

Quantcast