Avg Age

G

Guest

I have a field in a report which calculate the average age of employees and clients. I have set the decimal places to 2 and also to 1 put the field prints out reports to the umpteenth decimal point. What should the properties for that field be set to so that the avg age is kept to 78.1 or 78 yrs 3 mos etc.
 
D

Duane Hookom

Set the format property to something like Standard.

--
Duane Hookom
MS Access MVP


Rene said:
I have a field in a report which calculate the average age of employees
Click to expand...
and clients. I have set the decimal places to 2 and also to 1 put the field
prints out reports to the umpteenth decimal point. What should the
properties for that field be set to so that the avg age is kept to 78.1 or
78 yrs 3 mos etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What part of CURRENCY doesn't access understand? 7
Trouble with expression 1
Average Age 4
AVG on time on a Report Group 1
How to have report generate an overall average? 1
averaging a field value if field value is greater then 0 access report 4
I'm stuck on developing a system to "flag" when 2 criteria are met 2
Access 2003 - calculating age 3

Top