Rounding Averages on my Report

[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

 

[Al Campagna]

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"

 

[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?

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

.

 

[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"

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

.

 

[Duane Hookom]

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


.

 

[Al Campagna]

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


.

 

[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....

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


.

 

[Duane Hookom]

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....

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


.

 

[Summing multiple fields on a form]

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

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


.

.