Show only duplicate items

[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)?

 

[Jim/Chris]

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

Jim

 

[Guest]

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?

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

Jim