Share via

Access Database Marking an item complete

Anonymous
2019-02-01T17:14:08+00:00

I have hundreds of records that are completed.  It will take more time than I have to go in and manually mark each record complete.  Is there a query that can be create to mark the records that need marked.  i do have a check box for the record to be completed.  Thanks

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-03T15:22:21+00:00

    Thank you worked perfect.

    Was this answer helpful?

    0 comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-02-01T17:16:03+00:00

    UPDATE table SET Completed=True;

    That should do what you need

    Was this answer helpful?

    0 comments