No, it can't be done. It's not possible (nor desirable) to have values of
table fields be dependent on the values of other fields.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


wrote in message
nk.net...
i am using asp and an access database and here's what i'm TRYING to do
i have 3 fields in the table (hrs_taken), (date), and (hrs_needed).
i also have an update form which updates hrs_taken and date, well anyway i
want the value entered in the form that updates hrs_taken
to add to the value allready there. for example: if the value in hrs_taken
= 9 and the person enters 2 in the form then i want the
value updated to = 11. i also want to make it so that when the value in
hrs_taken is = to the value in hrs_needed(15) a new record
is inserted, having the initial value of whats entered in the form, and
the record that = 15 is left alone. can this be done and
does anyone know of a good tutorial for this?
any help at all would be greatly appreciated!
thanks