Access Query Creation Issue: Finding Duplicates in Status Field

May 29, 2024
Reaction score
I'm trying to generate a Duplicate query in Access by utilizing the Qry Wizard and selecting the "Find Duplicates Query Wizard." However, when I proceed by selecting the only available table, tbl_, I encounter the following message: "You must select a table or query that contains at least one field that does not have the Memo or OLE data type."

All fields in the tbl are of the Long Integer type.

The table contains 1900 rows of data. I require a query that retrieves all rows with identical values in the Status field.

Thank you in advance