Use @XLookup. This returns the value and you can put it in a variable.

FlipGilbert wrote on Jan 26^th, 2009 at 8:49pm:


var vHave as String

       vHave = @Xlookup(@fn, brp_1, "Inventory!brp_no", "Trk2")
       WriteLn(vHave)

You don't have to WriteLn it out. That's just an example of using it once you have it.

@XLookup always returns a String. If you need it to be numeric then declare the variable as a Double and use @ToNumber to convert the returned value.

var vHave as Double

       vHave = @ToNumber(@Xlookup(@fn, brp_1, "Inventory!brp_no", "Trk2"))
       vHave = vHave * QtyOrdered
       OrderTotal = vHave

...or whatever it is you actually need to do with this number.