absolute value

[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

 

[Phil]

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

So, all this does is give yuo teh negative values, (otherise it gives
you "N/A", and you want to flip them?
IIf([QryClassActRpt.VarWComm]>=0,"N/A",Format(([QryClassActRpt.VarWComm]*(-1)),"Currency"))

 

[John Spencer]

Use the abs function for that report.

IIf([QryClassActRpt.VarWComm]>=0,"N/A",
Format(Abs([QryClassActRpt.VarWComm]),"Currency"))