Rounding Averages on my Report
in [Reports]
|
From: Al Campagna on 28 Apr 2010 00:04 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" <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message news:A0C7A4C1-4226-4A42-97E1-D4B4AAA16B36(a)microsoft.com... > 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" >> > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in >> > message >> > news:FCCA74BD-F944-42CA-8534-EBC087D1F798(a)microsoft.com... >> > >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 >> > >> > >> > . >> >
From: Summing multiple fields on a form on 28 Apr 2010 00:07 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" > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message > news:A0C7A4C1-4226-4A42-97E1-D4B4AAA16B36(a)microsoft.com... > > 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" > >> > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in > >> > message > >> > news:FCCA74BD-F944-42CA-8534-EBC087D1F798(a)microsoft.com... > >> > >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 > >> > > >> > > >> > . > >> >
From: Duane Hookom on 28 Apr 2010 00:42 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" <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message news:6B700584-C57D-4F46-BC34-52ADB08342D9(a)microsoft.com... > 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" >> <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message >> news:A0C7A4C1-4226-4A42-97E1-D4B4AAA16B36(a)microsoft.com... >> > 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" >> >> > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in >> >> > message >> >> > news:FCCA74BD-F944-42CA-8534-EBC087D1F798(a)microsoft.com... >> >> > >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 >> >> > >> >> > >> >> > . >> >> >
From: Summing multiple fields on a form on 28 Apr 2010 01:38 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" > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in message > news:A0C7A4C1-4226-4A42-97E1-D4B4AAA16B36(a)microsoft.com... > > 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" > >> > <Summingmultiplefieldsonaform(a)discussions.microsoft.com> wrote in > >> > message > >> > news:FCCA74BD-F944-42CA-8534-EBC087D1F798(a)microsoft.com... > >> > >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 > >> > > >> > > >> > . > >> > > > > . >
First
|
Prev
|
Pages: 1 2 Prev: Group totals in dynamic report Next: Report with buttons to open forms |