can this be done

[Guest]

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

 

[Douglas J. Steele]

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

(no e-mails, please!)

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