Filter

J

Jock W

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?
 
J

Josh D

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*"
 
J

Jock W

Thanks guys
--
Jock Waddington


Josh D said:
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*"
Click to expand...
 
Top