Filtering for Unique Entries

  • Thread starter Thread starter Stefano Condotta
  • Start date Start date
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
 
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.
 
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...
 
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!
 
Back
Top