calculations in a query

[acd2]

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

 

[jwindon]

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

 

[acd2]

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

 

[jwindon]

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?