UniqueValues not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database template, I use a new copy every time I start a new
project. In this database there is a query that pulls from 6 tables using 11
fields from those 6 tables. UniqueValues is set to yes under properties.
This query works most of the time, but sometimes it doesn't. Sometimes, it
will show the duplicate values. Is there any way to fix this? I have tried
recreating the query and it still is tempromental.
 
I've never seen it fail. Are you sure that every field that you are
displaying is duplicated? (Watch out for extra spaces between words).

If you are sure this is failing, I suggest you post more information.
What version of Access?
What is the SQL statement?
Perhaps, copy and paste two of the duplicate rows.
 
Back
Top