Using DISTINCT in a WHERE Clause

[CD Tom]

To save some code I would like to put a distinct clause in the criteria for a report. I've created a table that I'm using for multiple reports but in some of the reports I only need one instance of a record but need multiples of that record in other reports. I'm using the same report layout with 7 different criteria's. So is there a way to put a distinct clause or some other statement that would select only unique records in a where clause(criteria)
I hope this makes some sense

[NeoPa]

DISTINCT is a keyword used in the SELECT clause only. It cannot be used in the WHERE clause as that would make absolutely no sense. You could use a GROUP BY clause and have similar results but it wouldn't be exactly the same thing.

Are you thinking about using a filter string?

[CD Tom]

No I'm not thinking of a filter. I'm thinking that I will create a couple of queries one with the distinct. I'll create them in the program in the section before I print the reports.

[NeoPa]

In that case you should now have all the information you need.

Be aware there are two related keywords :
DISTINCT
DISTINCTROW

The first applies only to the fields SELECTed whereas the second applies to the whole row regardless of which fields are used.