View Full Version : Form Calculations.


Criosti
06-27-2000, 03:06 AM
Need some help please as i am neewbie at access 97. I have created a from which has 22 combo boxes which one can select a score of 1 - 5. (A total maximum score of 110 can be achieved)I then have box which works out the precentage of the overall score should the 22 boxes filled.eg Say i score 55 out of a possible 110 i have achieved 50%. The problem i have now is that it is possible that not all the boxes are going to be filled but i still need the end total as a percentage. i hope this makes sense to someone.
Thanx in advanced Criosti

KevinM
06-27-2000, 04:02 AM
Use the Nz (Null Zero) function to account for null values....
e.g..

=Nz([Combo1)+Nz([Combo2]) etc etc