allen browne

Okay, good. For some reason there is not an exact match on this string
value.

Is there any chance that there is a space in the field (e.g. " Complete")
that's preventing the match? Any language issues that could affect the
outcome, e.g. an accent over an "e"?

If you can't spot the difference, you could create a query into this table,
copy the "Complete" to clipboard from the datasheet, switch to design view,
and paste it back into the Critieria row. Check that the right records are
returned. Switch the query to an Update query (Update on Query menu). Type
"Complete" into the Update row (without the quotes). Run the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to the newsgroup. (Email address has spurious "_SpamTrap")