I've asked this in a few forums but no solution. Maybe this is the correct forum. I'm looking to find duplicate records but I can't seem to get thebindingsource to do so. I'm looking for something like this: (where ssn is my column name....)

mybindingsource.Filter = "ssn HAVING COUNT > 1"

I want to return only records that have two or more ssn's. I know the Sort can handle DESC or ASC, but does Filter have any key words? Should I be using a different method?

Thanks in advance!

You canachieve this by using a sql as:

select * from table where ssn in
(
select ssn
from table
group by ssn
having count(*) >1
)

but a RowFilter cannot contain a sub query,

For more information about RowFilter expression, read THIS.

Best Regards,

Ye

You canachieve this by using a sql as:

select * from table where ssn in
(
select ssn
from table
group by ssn
having count(*) >1
)

but a RowFilter cannot contain a sub query,

For more information about RowFilter expression, read THIS.

Best Regards,

Ye

Thanks Ye!