SELECT DISTINCT

[Katie]

I am using Access 97 and when I write DISTINCT after the
SELECT in the SQL view of a query I get a syntax error in
my query...but isn't this how I would avoid selecting
duplicates? I know the rest of my syntax is
correct....Does anybody know what the problem could be.

 

[Roger Carlson]

You didn't say what the error was, but if it is "ORDER BY clause conflicts
with DISTINCT", it means that you are sorting on a field that is not in the
field list. Either show that field in the field list (in which case, it
will participate in the distinctness of the record) or sort on some other
field.

 

[Rick]

Katie,

Would you paste the SQL statement into a reply so we can
see it?


Thanks,

Rick