Solved

Concatinating Percentage to Controlsource

Posted on 2011-02-11
1
288 Views
Last Modified: 2012-05-11
For a control, I don't want to use the Format called "Percent".  Instead I want to concatinate "%" onto this controlsource code (only if the value is over 0).

=Avg(IIf([BankEntitlementDifference]>0,CInt((1-[HoursRemaining]/[HOURS])*100)))

How can I modify this syntax to put a percentage sign on the end of the value displaying on the report?
0
Comment
Question by:gcgcit
1 Comment
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 34873711
You can't add a % symbol to a field if it's defined as a number except through using a percent format.

If you want to add your own % symbol you must define the field as text - but of course it then can't be used directly as a number in calculations.
Why not just add a label control to the right  of the textbox that just contains the % symbol.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now