Need Help with a calculated expression

[mkelly]

This is the expression, however if the volume is below the reorder point it returns a -1 if it is not it returns a 1. Does anyone know how I can make it return a text message? I would like it to return "REORDER" if it is below the reorder point and nothing if it above the reorder point. Any help would be graetly appriciated.

=[ReorderLevel]+([Sum Of UnitsOrdered]-[Sum Of UnitsReceived])>=[Sum Of UnitsReceived]-[Sum Of UnitsShrinkage]-[Sum Of UnitsSold]

 

[David R]

Is this a field in a query? You can use

=Iif([CalcField]=-1,"REORDER","")

in an unbound text box in your report, I believe.

HTH,
David R