hi there i cant figure out how to get a percentage from a form i have created maybe one of you people can help me. the form i have has all of this on it:
date,new orders,new, used,replacement orders,new contract,short in bundles,
total,total new, used total,total percent.
i have copied and pasted a (totalpercent) textbox on the form footer to calculate the total sum of the (total percent) now i need to divide what ever is in the (sum of totalpercent) by how many days are in the date column...for instance if there are only three dates then i would divide whatever is the total of the (sum of totalpercent) by 3 to get a percentage of that week or if there was 4 dates i would divide the (sum of totalpercent) by 4 to get a percent of that week.
i have had buttons on this form to calculate this but i don't want buttons i want the percent to show up as soon as i start putting numbers in the form so i can print a report and have it ready to print. i hope this is understandable to who ever reads this. if you can imagine how this form looks you would see a column of date. a column of new orders, a column of used. and sofourth.
if you can help that would be great if not direct me to someone or a page that will
thanks,
lee123
