Can't delete some records using delete query

[Brian Anderson]

I have a Macro set up to run several queries. The first
query deletes all current records in my destination table
so I start fresh everytime.

When I run the Macro, I get the following error:

"The search key was not found in any record."

Any ideas why this is happening and how I fix it?

Thanks.

 

[John Vinson]

When I run the Macro, I get the following error:

"The search key was not found in any record."

Any ideas why this is happening and how I fix it?

It's probably happening because the search key was not found in any
record. Care to post the steps of your Macro and the SQL of the query
that's triggering the error?