Hi all
I have a number problem in my sports ( Frisbee dog ) points table.
The table is set up with the following fields; handler, dog, throw1,2,3,4,5,6,7,8,9,10,11,12,total points.
I have given each throw field a default value of 0.
I have given the total points field a calculation of throw1+throw2+throw3 etc all the way to throw12.
All of the above work fine. The only problem is I cant distinguish from what might be a score of 0 and the default value(0) which is important to me as I may need to calculate the average score per throw in the event of a tied score.
my Questions are 1) is there any way of making the default value invisible. 2) is there a better way of calculating my table this is my first ever database so im on a steep learning curve.
Any help will be very much appreciated
Thanx
Kevin