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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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