SQL Keywords

[Guest]

Is there any keywords other that DISTINCT and DISTINCTROW that I can use to
stop duplicate records from being printed in a mailing list. DISTINCT is used
when only one field is needed from a record. I tried to use it, but I got an
error because I need for than one field in the query. Duplicates are still
displayed when DISTINCTROW is used. Does anyone know a great forum or site I
can use to check SQL out in.

 

[Van T. Dinh]

You need to use a SubQuery to select a unique value from the Records you
want and then use the Main Query to selected the other details.

See The Access Web article:

http://www.mvps.org/access/queries/qry0020.htm

 

[Guest]

Thank You,
I will try that and see if it helps

Scott

You need to use a SubQuery to select a unique value from the Records you
want and then use the Main Query to selected the other details.

See The Access Web article:

http://www.mvps.org/access/queries/qry0020.htm