UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Round Up Percentage In Form Field, Access 2010    
 
   
guitarsweety
post Jul 17 2017, 09:32 AM
Post#1



Posts: 189
Joined: 1-December 11
From: Mt Airy, NC


What formula could I use to Round a percentage like 98.57 % to 99 %
Go to the top of the page
 
RAZMaddaz
post Jul 17 2017, 09:51 AM
Post#2


UtterAccess VIP
Posts: 9,522
Joined: 23-May 05
From: Bethesda, MD USA


Try the following:

expr:FormatPercent([YourFieldName],0)

Also, make the Property Sheet of the Field to "Percent" in the Format area.

RAZMaddaz
Go to the top of the page
 
MadPiet
post Jul 17 2017, 09:54 AM
Post#3



Posts: 2,222
Joined: 27-February 09



If you really mean to round (change) the value, you could use ROUND(). If all you intend is to show no decimal places, you could change the formatting.
Go to the top of the page
 
guitarsweety
post Jul 17 2017, 10:00 AM
Post#4



Posts: 189
Joined: 1-December 11
From: Mt Airy, NC


I tried round but it changed all of the percentages to 100%
Go to the top of the page
 
RAZMaddaz
post Jul 17 2017, 10:02 AM
Post#5


UtterAccess VIP
Posts: 9,522
Joined: 23-May 05
From: Bethesda, MD USA


If all you are doing is adding this Field in a Form, then all you should need to do is select the Field in the Form, view the Property Sheet and under the Format tab select "Percent" and make the "Decimal Places" set to zero.

RAZMaddaz
Go to the top of the page
 
guitarsweety
post Jul 17 2017, 10:07 AM
Post#6



Posts: 189
Joined: 1-December 11
From: Mt Airy, NC


I'm doing a dlookup in a table. If the percent of forecast is equal 99% the payment schedule should be %135.00 not $120.00. I can't seem to change the 98.57 to 99
This post has been edited by guitarsweety: Jul 17 2017, 10:07 AM
Attached File(s)
Attached File  Round.PNG ( 52.01K )Number of downloads: 1
 
Go to the top of the page
 
RAZMaddaz
post Jul 17 2017, 10:13 AM
Post#7


UtterAccess VIP
Posts: 9,522
Joined: 23-May 05
From: Bethesda, MD USA


QUOTE
I'm doing a dlookup in a table


The Evils of Lookup Fields
Go to the top of the page
 
guitarsweety
post Jul 17 2017, 10:32 AM
Post#8



Posts: 189
Joined: 1-December 11
From: Mt Airy, NC


I figured it out

CODE
=Round(Nz([Total Actual],0)/Nz([Total Budget],0),2)
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    19th November 2017 - 10:49 AM