I have several forms that we are interested in getting totals, avgs, etc. for some of the variables. these forms represents tasks that kids are doing. for ex. on one form i would like to calculate a total inconsistent score. i know how to write the calc. -- my ? involves the logistics of the form. i did create a variable beforehand called totincon and then when i built my query, i chose that variable and then wrote the expression but i get nothing when i run it. am i doing something fundamentally wrong. any suggestions are greatly appreciated.

Angela

This should help you out:
http://www.access-programmers.co.uk/ubb/Forum3/HTML/000199.html

i am not sure how you create a public function? can you be more explicit. when i try to run the query i am doing, i get a request for a parameter value?

thanks

What are the field names on the form that are calculated?

What field in the query do you need to match and what is the criteria? This totincon?