Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Course Of The Month
6 days, 10 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Fortmatting a Percenatge in a text box
Posted on 2013-01-14
I have the code below that when it calculates I get a value of
21.44067796610169491525423
I need it to be 21.44%.
How do I get it to format with out messing up the calculation? The calcution does this:
1. Counts the number that is 100 percent done
2. then it sums the percentage that is not 100% done
3. Totals those together (gives you 25.3)
4.then it divides that answer by 1.18
Here is the code:
=(DCount("[Percentage]","q
21.44067796610169491525423
I need it to be 21.44%.
How do I get it to format with out messing up the calculation? The calcution does this:
1. Counts the number that is 100 percent done
2. then it sums the percentage that is not 100% done
3. Totals those together (gives you 25.3)
4.then it divides that answer by 1.18
Here is the code:
=(DCount("[Percentage]","q
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6 Comments
Active 1 day ago
Use Format.
=Format((DCount("[Percentage]","qrytemplePercentage"," [Unit ]= ('2-1AD')AND Percentage IN('100') ")+Nz(DSum("[Percentage]","qrytemplePercentage"," [Percentage ] NOT IN ('100') AND Unit =('2-1AD')" & " AND " & " Not IsNull (InShopDate)")/100))/1.18, "#.00%")
Active 2 days ago
Format(21.4406779661016949
returns 21.44%
So, in a text box:
=Format(YourNumber/100,"Pe
returns 21.44%
So, in a text box:
=Format(YourNumber/100,"Pe
= Format(DCount("[Percentage]","qry
Use the round function like:
=round(21.4406779661016949
output is 21.44
=round((DCount("[Percentag
=round(21.4406779661016949
output is 21.44
=round((DCount("[Percentag
Active today
I've requested that this question be closed as follows:
Accepted answer: 168 points for imnorie's comment #a38775602
Assisted answer: 166 points for shorvath's comment #a38775616
Assisted answer: 166 points for DatabaseMX's comment #a38775607
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Accepted answer: 168 points for imnorie's comment #a38775602
Assisted answer: 166 points for shorvath's comment #a38775616
Assisted answer: 166 points for DatabaseMX's comment #a38775607
for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another.
Base the dependent combo on a query for its row source:
Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Suggested Courses
Course of the Month6 days, 10 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.