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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 . |
#7
|
|||
|
|||
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 . |
#8
|
|||
|
|||
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 | |
|
|