Updating records in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create an update query to uncheck several boxes at once and to
clear a field's content. How can I do that. I know it involves macros,
which I know nothing about.
 
Have you created an update query? This would be like:
Update tblYourTable
Set [YourYesNoField] = 0
Where ...some condition...;

Do you need to know how to run this query from code?
 
I am trying to create an update query to uncheck several boxes at once
and to clear a field's content. How can I do that. I know it
involves macros,
Click to expand...

UPDATE myTable
SET myBoolean = FALSE
WHERE someCriterion = TRUE


paste that into the SQL view of a new querydef; change the relevant names
to what your situation needs, and then click the ! toolbar button.

No macros.

Hope it helps


Tim F
 
Back
Top