Solved

Concatinating Percentage to Controlsource

Posted on 2011-02-11
1
279 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

914 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

21 Experts available now in Live!

Get 1:1 Help Now