Show only duplicate items

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

Guest

I have a report that list various files that are being worked.
Example:

FileName ProjectNumber
abc 1
xyz 2
abc 3
def 4

How can I show only the duplicate items (in this case file abc is duplicated)?
 
Create a query grouping and counting on filename. In the
criteria for the counted field put >1. Base your report on
this query.

Jim
 
I have a query with a field titled OMNumber (this is my filename, a filename
in this case is a five digit number such as 12345). When I designate the
criteria for this field as >1, the report does not change. I believe this is
only showing any number greater than 1 (which in this case is every entry in
this field). Is there another way to use Criteria which would only show me
duplicates?

Jim/Chris said:
Create a query grouping and counting on filename. In the
criteria for the counted field put >1. Base your report on
this query.

Jim
Click to expand...
 
Back
Top