I must be getting senile

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #221,084

by jbrabeck

8/26/05 2:38:28 PM

I must be getting senile

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!

A good friend will come and bail you out of jail ... but, a true friend will be sitting next to you saying, "Damn...that was fun!"

Post #221,122

by altmann

8/26/05 5:23:54 PM

Re: I must be getting senile

UniqueValues = No two records returned will have the same values in the fields returned. Equivalent to SELECT DISTINCT ... in SQL

UniqueRecords = No two records will have the same vaules in all fields of the source records regardless of whether that field is returned. Equivalent to DISTINCTROW in Jet (and SQL Server?) SQL.

--
Chris Altmann

I must be getting senile - (jbrabeck) - (1) - Aug. 26, 2005, 02:38:28 PM EDT

Re: I must be getting senile - (altmann) - Aug. 26, 2005, 05:23:54 PM EDT

iwethey.org

Pull. Snick! Push. Snick! Pull. Snick!
38 ms