I want to see the duplicates in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report which basically has names which are assigned to different
categories. Most names are only in one category but there are some that are
in more than one (as many as four). The report is fairly simple - the
category is on top and the names are listed below.

What I would like is to be able to highlight (or color or whatever) the
names that are in more than one category each time they appear. I think this
done through conditional formatting but I'm not sure and I don't know what
syntax or code to use.

Any help would be greatly appreciated.
 
I think you need to create a totals query that GROUPS BY the name and counts
the categories. Then add this totals query to your report's record source
query. Join the name fields. Use the CountOfCategories field with
conditional formatting in your report.
 
Thanks, but isn't there something simpler? I don't want to mess with the
queries that the report is drawing from. Also, there are already counts and
subcounts all over the report which I also don't want to mess with.
 
I don't believe you can reference a calculated summary from a group header
or footer section from within the detail section.

There should be no problem with creating a new query or adding a subquery in
your report's recordsource.
 
I don't think that's what I'm doing. The field is not calculated it's just a
name. What is calculated is the number of names in each category.

There should be some sort of "if this is a duplicate then highlight" type of
syntax but I don't know it since I don't know SQL and I'm not a programmer.
Any ideas?
 
You stated "field is not calculated" yet you need to "calculated is the
number of names in each category". I regard that as a calculated summary.

I already told you how to resolve this. Create a totals query that counts
and add it to your report's record source. It should take less time then it
takes to reply. Do you understand the steps? If not, I'm sure someone could
assist if we knew the table structure(s).
 
I don't think I described it well. Basically the report looks somthing like
this:

Category A Category B Catergory C
Name1 Name4 Name6
Name2 Name3 Name7
Name3 Name5 Name5
Name8
Total: 3 Total: 4 Total: 3

Notice that Name3 and Name5 each appear in two categories. All I want is to
be able to highlight those names. Is there a simple way to do this?
 
Can you share your table structure? Is this a multiple column report? Are
you using subreports for each category? What would your "raw" records look
like for this resulting display?
 
Back
Top