Not Like

[Rob Parker]

The Like expression is normally used for setting criteria for text fields,
usually in combination with (a) wildcard character(s).

To exclude any of the (integer) values 6, 9, 10, or 11, you can simply set a
criterion of:
Not In (6, 9, 10, 11)

HTH

Rob

 

[DS]

I have a number field in my query and I need the criteria to be...

Not Like 6
Not Like 9
Not Like 10
Not Like 11

It can't be like any of the above...but the 6 is throwing me off.
How can I do this?
Thanks
DS

 

[DS]

The Like expression is normally used for setting criteria for text fields,
usually in combination with (a) wildcard character(s).

To exclude any of the (integer) values 6, 9, 10, or 11, you can simply set a
criterion of:
Not In (6, 9, 10, 11)

HTH

Rob

Thanks, it's perfect!
DS