Count Duplicate Fields

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

Guest

This is the last step in completing my database. Here are the specifics:
I have a report based on an order form based on table "tOrders". Some
customers have multiple orders. I used conditional formatting in my report
to have certain text boxes turn yellow if a customer appears more than once.
I used this conditional formatting:
DCount("*","tOrders","[Last] + [First] = " & Chr(34) & [Last]+[First] &
Chr(34))>1

Now I would like the report to count how many times a particular first and
last name appear and display it. For example, Joe Smith ordered a prime rib,
a turkey and a spiral ham. Next to his name on the report I want it to
display the number 3. If a customer has only a single order (no duplicates)
I want that display to be blank.

I created a "find duplicates query" and was able to get the count there.
However, when I try to bring that query into the report it won't allow me
because I am using a table and a query based on that table. Of course.

I dunno'. I'm sure it's very easy, but I'm really burnt out on this thing
and need a little help.

Thanks,
Ben
 
There should be no reason why you can't add your find duplicates query to
your report's record source. This is fairly common practice. Did you get an
error message? Your solution is probably what I would have recommended.
 
Back
Top