By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Averaging figures

P: n/a
oyk
I want to average figures by row. The rows of the queries consist of figures
for Yr1Salary, Yr2Salary, Yr3Salary etc. until Yr28. I want to average these
figures. Anyone able to help me? TQ.
Oct 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

oyk wrote:
I want to average figures by row. The rows of the queries consist of figures
for Yr1Salary, Yr2Salary, Yr3Salary etc. until Yr28. I want to average these
figures. Anyone able to help me? TQ.
Normalize your table and then use a summary query. I posted some code
that fixed tables like this a while back.

Oct 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.