Setting distinct fields in queries without going to SQL statements

[Adrian]

Hi,

Is it possible to set some of the fields in queries to be distinct
without going to SQL statements ? If so, how ? Thanks...

 

[Roger Carlson]

If you mean: can you create a query with a DISTINCT predicate like this:

SELECT DISTINCT LastName, FirstName FROM Sometable

without going to the SQL window and adding the DISTINCT keyword, the answer
is yes.

In the Query Builder design window, right click on the upper portion (where
the tables show) and choose Properties. Change the property called "Unique
Values" to YES.