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