Hide duplicates in query

[hrg]

I have a query within a database. In the criteria cell i want to write

hide all duplicates (in the column)

the purpose so that if the same name appears on one day then i only want to show it once. But bearing in mind if it appears the next day then i want to show it.

Thanks

 

[Sawatzky]

dear hrg,

try the option distinct for your sql-statement.

select distince name from soucre
hth

regards astrid