not showing duplicate entry's

[killerwhale65]

Hi all,

I would like to create a query or filter that allows me the following:
some fields have the same value fore several records in the table. If that is the case, i only want to display them once. So for example if i have this table:

field1 field2 field3
A B C
D E F
A B C
X Y Z
X Y Z

i want to display this:
field1 field2 field3
A B C
D E F
X Y Z

Can anyone help me on this?

THANKS alot!

Matt

 

[pdx_man]

Check out the DISTINCT predicate. In query design mode, look at the query properties ...

 

[killerwhale65]

hi,

thanks alot for that answer! It seems to work perfectly well...

Matt