Table filter for only 1 count

[fallito]

Hi,

I have a table with multiple columns. One of them, named CausaAveria, has multiple entries that may repeat. I what to create a filter that displays just the name of the entry without displaying the entire list of results.

Anyone knows how to do this?

Thank you

 

[redneckgeek]

Are you saying you want to see just the unique values from that field?

 

[fallito]

Yes. That's what I meant. No duplicates.

 

[redneckgeek]

In your query designer window, bring up the properties box and set the Unique Values to Yes.