Solved

Concatinating Percentage to Controlsource

Posted on 2011-02-11
1
267 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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

771 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

11 Experts available now in Live!

Get 1:1 Help Now