>By setting DELETED ON and removing the NOT DELETED() line, both queries work fine.
>
>However, removing the index tag on DELETED() and leaving DELETED OFF does not work either.
>
>I guess I will leave DELETED ON when running these processes.
>
>Thank you for the help.

It is better to not use DELETED() function in a query.