Set all values in a field back to zero. (0)

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

Guest

I need to change all the values in a field on a form (that is linked to a
query and tables) back to zero, in order to enter new data for the new year.

Is there a way to program this rather than having to scroll thru each record
and manually type the 0 into the field for each record?

I can't seem to get it right.
 
Add a command button on the form that runs an update query that zeroes out
the field
 
Another way is to set the DefaultValue property of the form's controls to
zero, which will put a zero in the controls as the value when you start a
new record.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with add leading zero to value 2
Change values back to zero 3
Zero Upload Speed 6
Set values back to zero 1
To Zero or not to Zero 5
conditionally setting field values to 0 3
Zeros Showing in Form Field 4
Change blanks to 0 (zero) 5

Back
Top