A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Rounding Averages on my Report



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 06:44 AM posted to microsoft.public.access.reports
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Rounding Averages on my Report

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
  #2  
Old April 27th, 2010, 02:19 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Rounding Averages on my Report

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"
t.com wrote in 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



  #3  
Old April 27th, 2010, 08:43 PM posted to microsoft.public.access.reports
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Rounding Averages on my Report

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" wrote:

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"
t.com wrote in 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



.

  #4  
Old April 28th, 2010, 02:27 AM posted to microsoft.public.access.reports
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Rounding Averages on my Report

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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in 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



.

  #5  
Old April 28th, 2010, 04:47 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Rounding Averages on my Report

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"
t.com wrote in message
...
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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in
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


.

  #6  
Old April 28th, 2010, 05:04 AM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Rounding Averages on my Report

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"
t.com wrote in message
...
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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in
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


.



  #7  
Old April 28th, 2010, 05:07 AM posted to microsoft.public.access.reports
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Rounding Averages on my Report

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" wrote:

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"
t.com wrote in message
...
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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in
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


.

  #8  
Old April 28th, 2010, 05:42 AM posted to microsoft.public.access.reports
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default Rounding Averages on my Report

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"
t.com wrote in message
...
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" wrote:

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"
t.com wrote in message
...
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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in
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


.

  #9  
Old April 28th, 2010, 06:38 AM posted to microsoft.public.access.reports
Summing multiple fields on a form
external usenet poster
 
Posts: 38
Default Rounding Averages on my Report

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" wrote:

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"
t.com wrote in message
...
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

"Summing multiple fields on a form" wrote:

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" wrote:

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"
t.com wrote in
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


.



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.