Rounding Averages on my Report

  • Thread starter Thread starter Summing multiple fields on a form
  • Start date Start date
S

Summing multiple fields on a form

I created a summary report using the report wizard and grouped by date and
selected avg.

The report works fine except I would the numbers to be rounded. For example:

The average for January shows 19.5, however I would like it displayed as 20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx
 
Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
 
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


Al Campagna said:
Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
I created a summary report using the report wizard and grouped by date and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx
Click to expand...


.
Click to expand...
 
HELP!!!!!
Earlier I asked a question and received an answer. However, I am unsure of
the correct syntax. Again its a summary report and I am sorting by month.
Now I would like to average the fieldname 'Current' (a numeric field). I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct syntax
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


Al Campagna said:
Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
I created a summary report using the report wizard and grouped by date and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx
Click to expand...


.
Click to expand...
Click to expand...
 
If you want to display more or less decimal places, why not just use the
format and decimal properties?

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
HELP!!!!!
Earlier I asked a question and received an answer. However, I am unsure
of
the correct syntax. Again its a summary report and I am sorting by month.
Now I would like to average the fieldname 'Current' (a numeric field). I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the
fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct
syntax
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


Al Campagna said:
Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
message
I created a summary report using the report wizard and grouped by date
and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed
as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx


.
Click to expand...
Click to expand...
Click to expand...
 
You need to see the Format function in Help.
If needed, see the Val function in Help also.
That's how you learn the correct syntax...

= Format(Avg([Current]),"#")
or
= Val(Format(Avg([Current]),"#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

"Summing multiple fields on a form"
HELP!!!!!
Earlier I asked a question and received an answer. However, I am unsure
of
the correct syntax. Again its a summary report and I am sorting by month.
Now I would like to average the fieldname 'Current' (a numeric field). I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the
fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct
syntax
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


Al Campagna said:
Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
message
I created a summary report using the report wizard and grouped by date
and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed
as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx


.
Click to expand...
Click to expand...
Click to expand...
 
Im sorry Duane, if Im not making myself clear. Im really new and trying to
lear so please bear with me. I am not trying to display more or less decimal
places but I am trying to round an averaged calculated field. No matter what
I try it doesnt work.

The =AVG funtion averages the field for me but I also want it rounded. Im
unsure of what the syntax should be. HELP ME HELP ME PLEASE....

Duane Hookom said:
If you want to display more or less decimal places, why not just use the
format and decimal properties?

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
HELP!!!!!
Earlier I asked a question and received an answer. However, I am unsure
of
the correct syntax. Again its a summary report and I am sorting by month.
Now I would like to average the fieldname 'Current' (a numeric field). I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the
fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct
syntax
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


:

Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
message
I created a summary report using the report wizard and grouped by date
and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed
as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx


.
Click to expand...
Click to expand...
Click to expand...
 
You stated in your first post:
"The average for January shows 19.5, however I would like it displayed as
20"
The absolute easiest and most common method for doing this would be to set
the Format property to Standard and the Decimal Places to 0.

This would also work on your other example:
"If February is 23.1678993, I would like it displayed as 23."

Did you try this?

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
Im sorry Duane, if Im not making myself clear. Im really new and trying to
lear so please bear with me. I am not trying to display more or less
decimal
places but I am trying to round an averaged calculated field. No matter
what
I try it doesnt work.

The =AVG funtion averages the field for me but I also want it rounded. Im
unsure of what the syntax should be. HELP ME HELP ME PLEASE....

Duane Hookom said:
If you want to display more or less decimal places, why not just use the
format and decimal properties?

--
Duane Hookom
MS Access MVP


"Summing multiple fields on a form"
HELP!!!!!
Earlier I asked a question and received an answer. However, I am
unsure
of
the correct syntax. Again its a summary report and I am sorting by
month.
Now I would like to average the fieldname 'Current' (a numeric field).
I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the
fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct
syntax
on averaging the field and having it displayed rounded... THX

:

Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


:

Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
message
I created a summary report using the report wizard and grouped by
date
and
selected avg.

The report works fine except I would the numbers to be rounded.
For
example:

The average for January shows 19.5, however I would like it
displayed
as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx


.
Click to expand...
Click to expand...
Click to expand...
 
Al,
MUCH THX to you....It worked! I appreciate the advise and will definitely
review the Format and Val functions. Again, TY TY TY.

Al Campagna said:
You need to see the Format function in Help.
If needed, see the Val function in Help also.
That's how you learn the correct syntax...

= Format(Avg([Current]),"#")
or
= Val(Format(Avg([Current]),"#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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

"Summing multiple fields on a form"
HELP!!!!!
Earlier I asked a question and received an answer. However, I am unsure
of
the correct syntax. Again its a summary report and I am sorting by month.
Now I would like to average the fieldname 'Current' (a numeric field). I
created a summary report and used avg as an option. The average is not
rounded. Based on the answer I received I chgd the property for the
fieldname
[current]

from =Avg([current])
to =Val(Avg[Current], '#'))

I receive a syntax error....Please help me with providing the correct
syntax
Thx Al...One more question, forgive me Im really new to this.....
the report shows the property of the field as: =Avg([Current])

The field is numeric. How do I modify that to show rounding?


:

Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

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



"Summing multiple fields on a form"
message
I created a summary report using the report wizard and grouped by date
and
selected avg.

The report works fine except I would the numbers to be rounded. For
example:

The average for January shows 19.5, however I would like it displayed
as
20.

If February is 23.1678993, I would like it displayed as 23.

Can someone help me with this? Thx


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top