Filter

[Guest]

How easy would it be to add a filter to this control:
(qryJointWater.fldSanitising)="3" or ISNULL (qryJointWater.fldSanitising)
so that anything in field.account starting with "ZZ" is ignored?

 

[Guest]

how about
Not Like "ZZ"&"*"

 

[Guest]

Its easier to exclude a none-wanted item then selecting all others.

Not like "*ZZ*"

will exclude everything that contains ZZ anywhere in the text. If the ZZ
appears at the begining of the text change to "ZZ*"

 

[Guest]

Thanks guys
--
Jock Waddington

Its easier to exclude a none-wanted item then selecting all others.

Not like "*ZZ*"

will exclude everything that contains ZZ anywhere in the text. If the ZZ
appears at the begining of the text change to "ZZ*"