Control Source

  • Thread starter Thread starter Greta
  • Start date Start date
G

Greta

Access 2002...

I have a control on a form with this in the control source:
=IIf([Fail Tot]="10","ALL",[Fail Tot])
What it does is say if all the tests failed (10 total
tests) or, if not, how many did. All I want now is to
have the word "Fail" put infront of the number or the
word "ALL". I can't seem to figure it out. Any help?
Thanks,
Greta
 
Have you tried something like the line below?

=IIf([Fail Tot]="10","Fail ALL","Fail "&[Fail Tot])

-Ed
 
Back
Top