Help Please

Tush · 17 Jan 2006 at 10:13

Thanks for taking a look at this in advance. I have a form in ASP, which writes to an Access Database. In the form there are 3 particular fields, which requires a numerical calculations. This feilds are called Allocation 1 , 2 and 3.

If there is data in only one of the fields COSTCODE then Allocation 1 = 100%. If there is data in 2 COSTCODE feilds then Allocation 1 and Allocation 2 is 50/50 in each Allocation feild, and if there is data in 3rd COSTCODE feild then its 100% divide by 3 = 33.3% in all 3 Allocation feilds. Hope this makes sense!

Cost Code 1 Allocation 1 = 33.3%
Cost Code 2 Allocation 2 = 33.3%
Cost Code 3 Allocation 3 = 33.3%

Total = 100%

Tush · 17 Jan 2006 at 10:38

Sorry if this is not clear, what i am asking is how do i get my form to display/workout the above calculation?

Tush · 17 Jan 2006 at 15:01

Know one knows how to create this javascript ?

Tush · 17 Jan 2006 at 16:22

Ok i am really sorry about this guys I am farley new at the whole thing!
Anyways here is another attempt at explaning this!

All three feild should be equally divinded in 100% The information is displayed in the form itself. For example lets say i click on costcode 1 feild in the form. The very next which is allocation 1 would display 100% in it automatically. Then lets say i entered cost code 2 the very next feild called allocation 2 would display 50%, at this point however the first feild allocation 1 for costcode1 would also display 50%.

Let say i entered costcode 1 4444 Allocation 1 = 100%
Then lets say i entered costcode 2 5555 Allocation 2 = 50% and so is Allocation 1!

Basically both feilds are equally divided into 100%. Hope this is clear!
There does not need to be a calculation when someone submits a form, the information is purely for users information.

Tush · 17 Jan 2006 at 17:03

Hope this can explain better

Tush · 17 Jan 2006 at 17:05

How do i attach pics to this post. I've just tried and its just listing the path!

Tush · 17 Jan 2006 at 17:15

Ok I really hope the below explains the below!

[/URL][/IMG]

Tush · 17 Jan 2006 at 20:51

Hi roboffer
Thanks for doing this, I’ll give this a try and let you know how its going!
Once again thanks for all your efforts really appreciate it!

Tush · 18 Jan 2006 at 11:44

Hi roboffer,

I am just writing to say that i've tried this and it works exactly as required! Thanks for all your help. I just wanted to know one more thing which is how do i get the Total feild to add them together as the costcodes are entered in each feild/s.

once again thanks for all your help!

Tush · 18 Jan 2006 at 12:37

Hi roboffer,
thanks for this i already tried the above and it also worked for the total feild!
thanks for all your help