Control Source

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
 
E

Ed Robichaud

Have you tried something like the line below?

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

-Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronization problems while moving folders to new email 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Updates for excel 2002/3 0
Using the list form control: multi-selection possible? 3
How to add a count in query for reports 1
Create form with checkbox les that expand and collapse sections of the form? 0
Number Error Problem 3
Runtime error 2147467259 (80004005) method return address of object envelope failed 2

Top