Average 1

[kastaman]

I have a query where one of the columns calculates the % from 2 other columns.

My question is: what formula do I need to create that will show the average of the records that have been entered.

My second question is: How do I create the same info in a report.

Kastaman

 

[67peshawar294]

Kastaman,
On your form in the page footer add a txtbox and make it =avg([your field])
do the same thing for the report.
Jim

 

[kastaman]

Jpeneh10 - I'm not getting any results (?name). the field I want to calculate is a calculated field from 2 other fields. Does this make a difference?

 

[67peshawar294]

Try =avg([your field]+[your otherfield])
Jim

 

[kastaman]

Jpeneh10!!! That works! Thanks so much.

 

[kastaman]

one more question, how can I show the averages by month, although they are inputted on a daily basis, I would like the form to show the monthly averages.

Kastaman

 

[new9]

you might do that by adding Total (from the query menu) on your query.Then add the field [month] to the query. Finally, chose Group By for the the [month] field

Hope, this will help

 

[kastaman]

new9,

I'll try it and let you know if I have any probs.

Merci!

Kastaman