can you automate finding monthly avg and daily avg

Posted on 2011-04-28
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
    LVL 1

    Accepted Solution

    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

    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

    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

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now