B
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.
Goal - to determine % changes in this month's activity versus the yearly
average up to this point in time. I am looking at consumer spending habits
and want to know where they stand this month (number of purchases) versus
their average year to date
Table structure,
Account Number YearlyAvg Month1 Month2 Month3 Month 4 This
Month's average
xxxx 10 10 5 5
?????
The YearlyAvg field is made up from a union queary.
Thank you
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.
Goal - to determine % changes in this month's activity versus the yearly
average up to this point in time. I am looking at consumer spending habits
and want to know where they stand this month (number of purchases) versus
their average year to date
Table structure,
Account Number YearlyAvg Month1 Month2 Month3 Month 4 This
Month's average
xxxx 10 10 5 5
?????
The YearlyAvg field is made up from a union queary.
Thank you