Decimal Points in IIF statement in a Form

R

Ray

Is there any way of specifying the number of decimal
points in the result of a IIF statement?
For example:

=IIf([TOTAL_CHOL]<[CHOL_MAX],"Congratulations you are
within limits","Above limits by " & (([TOTAL_CHOL]-
[CHOL_MAX])/[TOTAL_CHOL]*100) & " %")

The [TOTAL_CHOL]and [CHOL_MAX] are obtained from a query
where the fields are formated to "Fixed Number with 2
decimal points".

I can remove the math calculation and write another IIF
statement to calculate the percentage, format the results
as required and then position the result in the correct
place on the form, but I was wondering is there a way to
specify the formatting in the above IIF statement.

Thanks for your help.
Ray
 
F

fredg

Ray said:
Is there any way of specifying the number of decimal
points in the result of a IIF statement?
For example:

=IIf([TOTAL_CHOL]<[CHOL_MAX],"Congratulations you are
within limits","Above limits by " & (([TOTAL_CHOL]-
[CHOL_MAX])/[TOTAL_CHOL]*100) & " %")

The [TOTAL_CHOL]and [CHOL_MAX] are obtained from a query
where the fields are formated to "Fixed Number with 2
decimal points".

I can remove the math calculation and write another IIF
statement to calculate the percentage, format the results
as required and then position the result in the correct
place on the form, but I was wondering is there a way to
specify the formatting in the above IIF statement.

Thanks for your help.
Ray
Click to expand...

Ray,
="Text here " & Format(Expression,"#.00%")
Try:
=IIf([TOTAL_CHOL]<[CHOL_MAX],"Congratulations you are
within limits","Above limits by " & Format((([TOTAL_CHOL]-
[CHOL_MAX])/[TOTAL_CHOL]*100),"#.00%")
 
Top