distinct count

I have a table with 4 columns and there are many many records. I need to run a query to report back how many
distinct records there are and if some of them are duplicated.
This sql table does not have any primary keys so when the import of data from access was done, the same record could have been inserted multiple times
so I figure a query that returns all the distinct records and a count of how many are there it will help determine this. See below is a total of 8 records
but my query with the distinct should only return 4 records back and a counter.

I look forward to some feedback



filename      itemnumber      description

23423.jpg      345            this is for the west side
24443.jpg      346            this is for the noth side
33423.jpg      347            this is for the south side
44423.jpg      348            this is for the east side
23423.jpg      345            this is for the west side
23423.jpg      345            this is for the west side
33423.jpg      347            this is for the south side
44423.jpg      348            this is for the east side



filename      count

23423.jpg      3
24443.jpg      1
33423.jpg      2
44423.jpg      2Start Free Trial