[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


can you automate finding monthly avg and daily avg

Posted on 2011-04-28
Medium Priority
Last Modified: 2012-05-11
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
Question by:davetough

Accepted Solution

mona4980 earned 2000 total points
ID: 35487780
You could always put in your query: WeekleyAverage:[quantity installed]/7
that would give you the average of quantity installed for the week. A better way would to put a date of install in the table. That would be the only way you could average how many per day.
LVL 44

Expert Comment

ID: 35488452
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.

Author Comment

ID: 35488596
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question