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