M$ Access Query

"SELECT DISTINCT"

[jk3210]

I'm trying to restrict an Access query to only one instance of a record in the query. So far I've tried setting the query properties to:

"Unique Records" then "Unique Values"

And I've tried using "SELECT DISTINCT" but nothing is working.

And ideas?

[Robino]

Which instance?

Haven't used Acce$$ in a while but can't you just use

where

or

firstOf

?

[jk3210]

>>Which instance? <<

The first one. "firstof" should work, but I must be doing something wrong.

[Robino]

Sticky me the SQL and I'll look at it.