How to correctly use the SELECT DISTINCT predicate in MS Access?

R

Rita

I am getting syntax errors when trying to use the SELECT DISTINCT predicate
in my query. Has anyone had any success getting this to work properly, and
if so, what is the correct syntax. I have tried to work with this for three
days now and have had no success in using this. Any help would be
appreciated.
 
D

Dale Fye

I use it quite frequently when I don't have a lookup table for some aspect of
an application or database.

A little better explaination of what you are trying to do would help. Maybe
include the SQL statement along with a description of your table structure
look like. What fields are you trying to use, is one of them a memo field
(you cannot SELECT Distinct on a memo field).

HTH
Dale
 
Top