Using Access (2003?).
In a query, What's the difference between UniqueValues and UniqueRecords?
I just did an experiment, and got different results. With UniqueValues I had fewer records returned. UniqueRecords had duplicate records in the results table.
So, why does UniqueValues really give me unique records in the output and why does UniqueRecords give me duplicates?
I love Access ------ NOT!