🚀 go-pugleaf

This should work, at least from ADO - Jet supports subqueries:

select * from
(select MyText, count(MyText) as c
from SomeTable
group by lang1_MyText)
where c > 1

Note also that Counter is reserved work and should be enclosed in brackets - 
[Counter].

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Vladimir Stefanovic" <antivari@po.sbb.co.yu> �������/�������� � �������� 
���������: news:421b7242$2@newsgroups.borland.com...
>I have a table (MS ACCESS) with 2 fields:
>
>   1 field: MyText (TEXT)
>   2 field: MyBool (BOOL)
>
> ...which both should make a primary key, but first I
> have somehow to get rid of duplicates:
>
> I need an SQL which can find duplicates for me by
> any of those tools: SQL Explorer, MS Access Query or
> BCB6&ADOQuery.
>
> Also why this do not work with any of the tools mentioned:
>
> // This is only for a single field, not for both
> select MyText, count(MyText) as Counter
> from SomeTable
> group by MyText
> where Counter>1
>
>
>
> -- 
> Best regards,
> Vladimir Stefanovic
>