Search key not found

I have a table (Receive) with a field Named "Due". It is a data type yes/no field. It defaults to yes or -1 or checked. SQl statment

DELETE Receive.Due
FROM Receive
WHERE (((Receive.Due)=No));

Causes a search key not found error.
Same happens when 0 is used.

How do I fix it?

Microsoft AccessSQL

Last Comment

aikimark

8/22/2022 - Mon

SOLUTION

4/13/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

ASKER CERTIFIED SOLUTION

4/13/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

4/13/2016

You can also try importing all records in to a new table, and if successful ... replace the original table with the new table.

aikimark

4/13/2016

Try this

DELETE *
FROM Receive
WHERE Receive.Due = False;