Divide yearly average by present month data

[btvs6]

Hello,

I am trying to create a a query that keeps a running percentage of this month's activity versus the yearly average (yealyavg/thismonth). I have already created a query for the yearly average and that is running smooth and updates automatically when new data is added to future months in the table.

Thus,

YearlyAvg Month1 Month2 Month3...Percentage
10 10 5 15 ???

Thank you

 

[dhookom]

Could you share your table structure and some records of significant information?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]