Hi,
Use DISTINC in SQL statement. It is standard in ANSI SQL
and should work against any database paltform.
Val
Quote:
>-----Original Message-----
>Hi,
>I am not sure which one I should use when I query data
>from Access using ADO. In Access, DistinctRow seems the
>correct syntax, whereas in VB it seems not to work.
>Any ideas/suggestions?
>Thanks in Advance.
>Andy
>.
Distinct or DistinctRow