Link to home
Start Free TrialLog in
Avatar of davetough
davetough

asked on

can you automate finding monthly avg and daily avg

hello,
once a week i export data form a database into excel and join it with the new weeks data and create an avg weekly usage- an import back in- the sample database i have - is based on 2 weeks.
They are going to start importing data into database daily- is there anyway to automate a daily average for the year and also still have a weekly average and not do it manually?
thank you
am trying to do it in query- but if can only do in report or form - is okay
Avgdatabase.mdb
ASKER CERTIFIED SOLUTION
Avatar of mona4980
mona4980

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
A weekly average along side a monthly average makes no sense.  What are you trying to do?  If you have a product and want to show 4/5 weekly averages along side a monthly average all containing the same value, that is different.
Avatar of davetough
davetough

ASKER

yes - i actually am wondering is it possible to have a daily average qty?
they told me weekly average qty is not enough-
So data will be imported daily -
right now I just manually figure weekly average- by taking qty installed divided by number of weeks since January 1st. my example is just like as if 2 weeks of january passed.

thank you