Every time i run a certain query i will get the results - machNo Sum Weight ie
m1 wt200
m2 wt400
m3 wt250............etc
all i want is that an undefined field box on a form that will automatically show the sum weight value if machno is 1, similarley another undefined field box on the form that will automatically show the sum weight if machno is 2.Without any user imput. I can get the results by doing queries no problem, but for peace of mind i would like to find a way of coding the undefined field on the form as the solution to this problem. Thank you, Regards
m1 wt200
m2 wt400
m3 wt250............etc
all i want is that an undefined field box on a form that will automatically show the sum weight value if machno is 1, similarley another undefined field box on the form that will automatically show the sum weight if machno is 2.Without any user imput. I can get the results by doing queries no problem, but for peace of mind i would like to find a way of coding the undefined field on the form as the solution to this problem. Thank you, Regards