Filtering for Unique Entries

S

Stefano Condotta

Hello,

I have a simple query with one field of "PayPeriods". I would like to enter
some criteria value that would remove duplicate values and leave me with a
set of unique values. I have the query as a rowsource for a combobox on a
form.

Regards,
Stefano
 
J

John Vinson

Hello,

I have a simple query with one field of "PayPeriods". I would like to enter
some criteria value that would remove duplicate values and leave me with a
set of unique values. I have the query as a rowsource for a combobox on a
form.

Regards,
Stefano
Click to expand...
]
Set the Unique Values property of the query to True.
 
S

Stefano Condotta

Thank you. I'm new to Access. I didn't know those properties existed.

Stefano

John Vinson said:
Hello,

I have a simple query with one field of "PayPeriods". I would like to enter
some criteria value that would remove duplicate values and leave me with a
set of unique values. I have the query as a rowsource for a combobox on a
form.

Regards,
Stefano
Click to expand...
]
Set the Unique Values property of the query to True.
Click to expand...
 
J

John Vinson

Thank you. I'm new to Access. I didn't know those properties existed.

Stefano
Click to expand...

Right you are... there're rather obscure and Access doesn't make it
easy to find them!
 
Top