Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Concatinating Percentage to Controlsource

Posted on 2011-02-11
1
Medium Priority
?
329 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 2000 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

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Question has a verified solution.

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

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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.
Suggested Courses

810 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