can this be done

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

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
 
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
Click to expand...
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
Click to expand...
= 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
Click to expand...
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
Click to expand...
the record that = 15 is left alone. can this be done and
 
Back
Top