Sort error in query - record is deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm very familiar with working with Access and creating and sorting queries,
but today am having a problem I've never encountered and I need help fast.

When working with a query I created several days ago and have been using
regularly, suddenly after I added information to quite a few records, when I
went to resort the query, I got the error "Record is deleted."

I closed the query and cannot reopen it -- I just get that same error message.

I can recreate the query, but when I try to sort it, I get the message again.

In addition, when I go back to queries that were created in the past, some
work fine and on some I can't open because I get the same error message.

What is wrong and how can I fix it?
 
Jeri said:
I'm very familiar with working with Access and creating and sorting queries,
but today am having a problem I've never encountered and I need help fast.

When working with a query I created several days ago and have been using
regularly, suddenly after I added information to quite a few records, when I
went to resort the query, I got the error "Record is deleted."

I closed the query and cannot reopen it -- I just get that same error message.

I can recreate the query, but when I try to sort it, I get the message again.

In addition, when I go back to queries that were created in the past, some
work fine and on some I can't open because I get the same error message.

What is wrong and how can I fix it?
Click to expand...

Sounds like a corrupt table(s) or query(s). Compact & Repair.
 
Back
Top