update query question

[Stephen]

good day

I have a table with two fields holding and paid both are yes/no
holding is checked on when invoice received and approved
what I need to do is run a query to uncheck holding and check paid but I
can not seem how to set the query
can someone point to an example I can refer to

Thank You
Stephen

 

[KARL DEWEY]

Backup your databate.
You can use this query substituting your table name for [YourDataTable] --
But you need some criteria in the query as this will update ALL records.

UPDATE YourDataTable SET YourDataTable.Holding = 0, YourDataTable.Paid = -1;

 

[Stephen]

thanks