Singular

[Guest]

Hello,

Is this possible in Access 97?

DELETE *
FROM Offers AS A
WHERE Not Singular (Select 1 From [Offers] As B Where ((B.[Part#] =
A.[Part#]) AND
(B.[Date] =
A.[Date]) AND
(B.[Prefix] =
A.[Prefix]) AND
(B.[TargetPrice] =
A.[TargetPrice]) AND
(B.[Company] =
A.[Company])));

I am using this to delete duplicate records.

Thank you,

Tracy

 

[Guest]

I run it and get the following error:

"At most one record can be returned by this subquery."