R
RobertM
The statement below will report N/A if VarWComm is less than 0:
AmtOfLoss:
IIf([QryClassActRpt.VarWComm]<=0,Format([QryClassActRpt.VarWComm],"Currency"),"N/A" )
The statement below will report N/A if BuysSellsmatchYN = No:
Expr1:
IIf([QryClassActRpt]![BuysSellsMatchYN]="Yes",[QryClassActRpt]![VarianceWN/A],"N/A")
Any ideas of how I can get these to work together in one query feild?
Robert
AmtOfLoss:
IIf([QryClassActRpt.VarWComm]<=0,Format([QryClassActRpt.VarWComm],"Currency"),"N/A" )
The statement below will report N/A if BuysSellsmatchYN = No:
Expr1:
IIf([QryClassActRpt]![BuysSellsMatchYN]="Yes",[QryClassActRpt]![VarianceWN/A],"N/A")
Any ideas of how I can get these to work together in one query feild?
Robert