# Name

[NOVAmichelle]

I have a form which has 4 fields across...

Column A has a number in it
Column B has a number in it
Column C has the Total of A & B
Column D represents the percentage of the Total/Column A

Problem is that when there's no value, meaning no total, then i get #Name in the percentage.
How can I avoid this?

 

[PHV]

Play with the IIf and Nz functions in the ControlSource property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[NOVAmichelle]

thank you. do you have an example?????

 

[PHV]

What is actually the ControlSource of your percentage textbox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[NOVAmichelle]

=[SumOf01/05 LPcom]/[SumOf01/05 Total]

 

[PHV]

=IIf(Nz([SumOf01/05 Total],0)=0, 0, [SumOf01/05 LPcom]/[SumOf01/05 Total])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244