update query question

  • Thread starter Thread starter Stephen
  • Start date Start date
S

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
 
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;
 
Back
Top