Changing 0 to 1 in a table

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

Guest

Hi,

I want to run a query that will automatically change the zeros in a field to
a 1. I know how to do this manually by replacing a 0 with a 1 but I want to
have it in a query.

Thanks
 
Just build an unpdate query. Pull all the records with a "0" unsing your
criteria and change it to "1" using the Update To field.

Note: Access uses -1 to represent a "true" value. If you are working with
a true/false or yes/no field, you need to do a little more research before
you proceed.
 
Back
Top