CODEWITHSUNDEEP
sqldatabasems-access
S.aad
S.aad

Reputation: 538

MS Access Error on Delete Query

Please see the query below

DELETE [All Uploaded parts UK in 2012].ID
FROM [All Uploaded parts UK in 2012]
WHERE ((([All Uploaded parts UK in 2012].ID)=
   (SELECT Min([All Uploaded parts UK in 2012].ID) AS MinOfID
   FROM [All Uploaded parts UK in 2012]
   GROUP BY [All Uploaded parts UK in 2012].Title
   HAVING (((count([All Uploaded parts UK in 2012].ID))>1)))
));

I am getting the following error

At most one record can be returned by this sub query.

Upvotes: 0

Views: 39

Answers (1)

Andrea Vannini
Andrea Vannini

Reputation: 41

try to run this query:

DELETE [All Uploaded parts UK in 2012].ID
FROM [All Uploaded parts UK in 2012]
WHERE ((([All Uploaded parts UK in 2012].ID) IN
   (SELECT Min([All Uploaded parts UK in 2012].ID) AS MinOfID
   FROM [All Uploaded parts UK in 2012]
   GROUP BY [All Uploaded parts UK in 2012].Title
   HAVING (((count([All Uploaded parts UK in 2012].ID))>1)))
));

Upvotes: 1

Related Questions