Monthly Average in Access 2007

65 pts.
Tags:
Access 2007
Access 2007 functions
Database programming
Microsoft Access
Microsoft Access 2007
Monthly Average
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

Answer Wiki

Thanks. We'll let you know when a new response is added.

Riaan,

In Access 2007, try working with the table in Pivot table view. Open the table, go to the Views group, click the arrow and select Pivot table. Then, for example, you could add the Date field to the row field, then add the Data field you want to average to the detail area. You can then choose to limit the Dates by Month and then Sum the data in the data field, and then Average the Sums.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • mshen
    Are you using excel? What application are you using?
    27,385 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following