Problems with Duplicate Records Query??

[Nathon Jones]

Hi,

I'm trying to run the duplicate records query using the wizard in Access,
but when I select which table I want to run the query on, it gives me the
following error:

"You must select a table or query that contains at least one field that does
not have the Memo or OLE data type."

This is a standard table, with a unique primary key!

Can't work it out!?
Hope someone can tell me this is a bug or something, because it just doesn't
make any sense. Thanks.

Nath.

 

[Arvin Meyer [MVP]]

You cannot check for duplicate values on a memo field. You can, however,
write queries which read the first 255 characters and check them for
duplicates.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access