How can I use a form to add numbers to an existing amount in a table field? The database works with numbers worked and I would like to have a text box on the form where you can type the new hours in and it will automatically add them to the past total in the base table.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access97 data entry problem
- Thread starter MAC104
- Start date
Wrong. We don't do formulas in a table. We do them in queries. Base your form on a query instead. If it needs to change the table, make it an Update query that'll update the table when you run it.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
Sorry, didn't mean to sound "superior" there...
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Brainbench MVP for Microsoft Word
- Status
Similar threads
- Locked
- Question
- Locked
- Question