NeilBelgium
IS-IT--Management
dear all,
how to add a value from a form into an existing numerical field?
I'm designing a db to record ratings for employees, which may be given by several of their colleagues.
I'm using asp/access/iis, and also have UltraDev as I believe this will take a lot of the time out of the process.
I'm stuck, though.
say I have a field called Question1, and I have a form that can insert into this field. Fine. But what happens when another person enters a score. What i need is a field Question1average, and a method of adding the second persons input to the first, and so on, instead of overwriting.
Presumably some method of calling the original value, adding this to the second value in an asp, and then putting both together and back into the db.
But how? my asp is limited, and I need to know how to do this.
much appreciated, neil
how to add a value from a form into an existing numerical field?
I'm designing a db to record ratings for employees, which may be given by several of their colleagues.
I'm using asp/access/iis, and also have UltraDev as I believe this will take a lot of the time out of the process.
I'm stuck, though.
say I have a field called Question1, and I have a form that can insert into this field. Fine. But what happens when another person enters a score. What i need is a field Question1average, and a method of adding the second persons input to the first, and so on, instead of overwriting.
Presumably some method of calling the original value, adding this to the second value in an asp, and then putting both together and back into the db.
But how? my asp is limited, and I need to know how to do this.
much appreciated, neil
