Unique Querie Results from a select query

[thesproing]

Hey guys,

Is there a simple way of only returning unique lines in your results from a select query?

Let me know if you need more detail, but im hoping its something obvious / easy.

Thanks,

 

[SydneyGeek]

In Design view, pick the SQL view.
The query will start with SELECT [the rest of the query]; change this to SELECT DISTINCT [the rest of the query]

Denis

 

[thesproing]

Brilliant! thanks!