Delete Reversals - Select Duplicate qry doesn't work

[SusanStoHelit]

I work with claims data, and I need to be able to analyze data on claims that we have actually paid.

In our data there are some claims that were paid and later reversed, or paid, reversed, and paid again (for a different or same amount) with the same ID number.

Is there a way to select and eventually delete the claims that have the same ID number and the same absolute claim amount?

I tried combining this criteria:

In (SELECT [ID_Number] FROM

As Tmp GROUP BY [ID_Number] HAVING Count(*)>1 )

With this criteria:

In (SELECT (ABS[ClaimAmount]) FROM [AUGMENTIN 2005] As Tmp GROUP BY (ABS[ClaimAmount]) HAVING Count(*)>1 )

And I get a sybtax error. Any ideas?