R
RobertM
Hello:
I've got the following IIf statement:
AmtOfLoss:
IIf([QryClassActRpt.VarWComm]>=0,"N/A",Format([QryClassActRpt.VarWComm],"Currency"))
If gives a negative value, which is what the database is supposed to do. My
dept director wants to see positive values for one report. Please tell me
what I need to add here.
Thank you,
Robert
I've got the following IIf statement:
AmtOfLoss:
IIf([QryClassActRpt.VarWComm]>=0,"N/A",Format([QryClassActRpt.VarWComm],"Currency"))
If gives a negative value, which is what the database is supposed to do. My
dept director wants to see positive values for one report. Please tell me
what I need to add here.
Thank you,
Robert