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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed column headings - using the IN predicate 1
SELECT DISTINCT query 8
COUNT and DISTINCT in Access 3
COUNT DISTINCT ? 5
Distinct count for each day 2
Selecting Distinct Memo Fields 1
perform INNER JOIN on query results 2
Query structure and distinct 7

Back
Top