Average

  • Thread starter Thread starter Joint Command and Staff Programme
  • Start date Start date
J

Joint Command and Staff Programme

I have a database query with three columns of information with calculations:
age, years in rank and years commisioned. I would like to get the average of
each column. Can anyone help?

thanks
 
Thanks for the help, can you tell me where I put the calculation?
 
Thanks, I do have columns to calculate age, years of service and years of
senority. Can you tell me where I put the average calculation?

Jeff Boyce said:
Another thought...

If your table has [Age], you would need to check (and update) the values
every day to make sure it's up-to-date.

A less labor-intensive alternative is to store Date of Birth, then use a
query to calculate Age. This has the advantage of always being correct,
without any update/maintenance.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Joint Command and Staff Programme" <Joint Command and Staff
(e-mail address removed)> wrote in message
I have a database query with three columns of information with
calculations:
age, years in rank and years commisioned. I would like to get the average
of
each column. Can anyone help?

thanks
Click to expand...
Click to expand...
 
If you have the calculations, then the averages can be done in any
Group, or Report footer.
=Avg(Age) or =Avg(YearsInService) ... etc
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Joint Command and Staff Programme"
Thanks, I do have columns to calculate age, years of service and years of
senority. Can you tell me where I put the average calculation?

Jeff Boyce said:
Another thought...

If your table has [Age], you would need to check (and update) the values
every day to make sure it's up-to-date.

A less labor-intensive alternative is to store Date of Birth, then use a
query to calculate Age. This has the advantage of always being correct,
without any update/maintenance.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Joint Command and Staff Programme" <Joint Command and Staff
(e-mail address removed)> wrote in message
I have a database query with three columns of information with
calculations:
age, years in rank and years commisioned. I would like to get the
average
of
each column. Can anyone help?

thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top