Does Actions support an expression?

[#1]

I am using QV 9 SR4

Using any of the actions, is it possible to select values from a field based upon an expression?

For example, on click of a button, I need to define something like -

"TRADE_NET_CV>250000"

This should select all records from the straight table where TRADE_NET_CV > 250000

Currently I am handling this through macro and was looking for a way to convert this to action.

Thanks in advance!

[#2]

You should be able to use the "Select in Field" action. Put TRADE_NET_CV in for Field and >25000 in for Search String.

[#3]

Tried that! but doesnt seem to work...

Surprisingly some of the values even though they are above 250k are omitted with that logic...

[#4]

Obviously I was doing something wrong. It has been fixed now.

Thanks!

[#5]

By the way, would it be possible to select values in a range... for example, I want to do something like -

='>' & NetCVLow & ' and < ' & NetCVHigh

Both the variables are set through input box and on click of a button, I am calling above action on select field for TRADE_NET_CV

This currently selects all the values! Could someone suggest what am I doing wrong!

Thanks!

[#6]

You shouldn't need to pass the operators as strings though I don't exactly how it will respond to multiple comparisons. You may want to play with a few varieties like these:

> NetCVLow AND < NetCVHigh

TRADE_NET_CV > NetCVLow AND TRADE_NET_CV < NetCVHigh

NetCvLow < TRADE_NET_CV < NetCVHigh