Distinct or DistinctRow 
Author Message
 Distinct or DistinctRow

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



Sat, 14 Aug 2004 22:39:04 GMT  
 Distinct or DistinctRow
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
>.



Sun, 15 Aug 2004 00:08:30 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Something like DISTINCT or DISTINCTROW, but what ?

2. SELECT DISTINCT vs DISTINCTROW with dynaset

3. difference between DISTINCT and DISTINCTROW (in a SQL query)

4. Something like DISTINCT or DISTINCTROW, but what ?

5. DISTINCT and DISTINCTROW in a SQL query?

6. SELECT DISTINCTROW?

7. SELECT DISTINCTROW year(y) FROM x will not work properly

8. Can I use DISTINCTROW in SQL Server 7?

9. Distinct Count on a Field?

10. Microsoft Access SQL: Distinct Count?

11. SELECT DISTINCT and memo field problem?

12. Does Access support SELECT Count(DISTINCT fieldname) ...

 

 
Powered by phpBB® Forum Software