Table filter for only 1 count (1 Viewer)

F

fallito

New member

Local time

Yesterday, 21:46

Joined

Oct 7, 2008

Messages

6

• Oct 28, 2008

• #1

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

 

R

redneckgeek

New member

Local time

Yesterday, 21:46

Joined

Dec 28, 2007

Messages

464

• Oct 28, 2008

• #2

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

 

F

fallito

New member

Local time

Yesterday, 21:46

Joined

Oct 7, 2008

Messages

6

• Oct 29, 2008

• #3

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

 

R

redneckgeek

New member

Local time

Yesterday, 21:46

Joined

Dec 28, 2007

Messages

464

• Oct 29, 2008

• #4

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