I have a report that is pulling data from a query. The query counts the number of clients that have accomplished a task. For example, let's say I have 10 clients, and 8 of them have accomplished the task in a certain time period. In the report, I have calculated [# of clients that have accomplished the task]/[total number of clients] = 80%.
Now, the program goal is to have 75% of the clients accomplish this task. So I need a field on the report that indicates "Yes" if the goal has been met, or "No" if it has not.
In this example, the 2 report fields would be like so:
Percent of clients accomplishing the task: 80%
Program Goal Met? Yes

I guess I'm not sure how to accomplish this.
Thank you.
Dennis

Try

=IIf(PercentField >= .75, "Yes", "No")

Thanks. I can't believe it was that easy.

depawl,

You can also use Conditional Formatting to highlight the field when the condition is met.

Wayne

Hi - I have something similar to this one though with text

What I want is to check a field for text - if there is some make the textbox visible - if not then don't...

So in my sql in the report I have

="Third Party " & [tblClaims!thirdPartyFname] & " " & [tblClaims!thirdPartyLname]


If no third party then set display to hidden..

Any Easy way of doing this...

Cheers
Andy

You could use code, but the simplest would be to use Conditional Formatting (set the font to white if no value).

Wonderfull - thanks, Just for those searching - Add this in the Conditional Formatting > Expression IS

[FieldName] Is Not Null

Set your control color Black - and in the report set it white - If text exists in the field it will show (obviously this is only any use if you have text within an expression attached to the control source of the textBox...


="Third Party " & [tblTest!FieldName1] & " " & [tblTest!FieldName2]


Which brings me to my next question...

Is it possible to format the above "Third Party " to be bold without having the resulting fields also bold
EG
Third Party Mr Someguy

Just came across this thread - Here's hoping it's not true
http://www.access-programmers.co.uk/forums/showthread.php?t=138257&highlight=Bold+expression

my somewhat oversized solution was to make a table of common Texts (tblCommonText) add it to the list for the report query and use the fields from that with the same expression minus the (expression) wording

=[tblTest!FieldName1] & " " & [tblTest!FieldName2]

thus getting my -

Third Party Mr Someguy

If anyone has a better solution please feel free to chip in

Andy