Question: what is the difference between unique values and unique records in access?
Answer: Unique values - Relate to the DISTINCT statement. It checks for unique values ONLY in in the fields selected for output, and eliminates duplicate rows. Just the two unique names in the list. The results are not updatable, since they are not necessarily corresponding to a unique record.