I have a query that I set in the properties as only showing unique values. When I ran the query, I got an error message that the field was too small to accept the amount of data I was trying to add. I found on the MS Support site that the characters were too long in my memo field. The site said to delete the memo field and then re-create the database using the memo line from the table and the new query.
I ran the query without the memo line, all runs well and no dups are displayed. When I merge the table and query together as it said I should, everything now displays twice. I even set the properties on the merged database to unique values, and it still shows me all data twice? Any suggestions would be appreciated.