SQL Keywords

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott - 19 May 2005 17:19 GMT

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.

Signature

Thank You,
Scott

Reply to this Message

Van T. Dinh - 19 May 2005 23:50 GMT

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

Signature

HTH
Van T. Dinh
MVP (Access)

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

Reply to this Message

Scott - 20 May 2005 00:51 GMT

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.
[quoted text clipped - 13 lines]
> I
> > can use to check SQL out in.

Reply to this Message