Can I filter on table column e.g. where greater than a number?

[#1]

Hi,

I would like to filter my table based on a formula on a column. For example, I have a column which shows how much a person has spent and I want to filter on people who have spent greater than £100 (for example).

Is there a simple way to achieve this?

Thanks
Mark

[Oleg_Troyansky]

Mark,

if you need to filter in your load script, you simply reload your table (with no concatenation) with a regular "where" clause.

In the runtime, you can use "Advanced Search" to define the formula. It's usually more than most users would like to do, so you might have to write a small macro to achieve that.

Oleg

[rbecher]

You can use search with formulas via "Advanced Search" (right click) on listboxes.

There is no search for tableboxes.

[#4]

Thanks gents.

Will look into this and have a play.

Regards
Mark