Filter out but leave blanks 1

[lars7]

Hi,
I I would like to filter out some grades from my query but when I do it like this:

<>"EXEC LVL 4" And <>"EXEC LVL 5" And <>"EXEC LVL 6"

It also filters out the blanks as some of the staff's grades are unknown at the moment but I still need to count them. It is also doing the same thing in some other columns too. Is there a way to filter out these groups and leave all the other staff still showing.

Thanks in advance.

 

[lars7]

sorry I feel like a fool :~/ it just needed a simple If statment in the column header.

 

[PHV]

Another way:
Not Like 'EXEC LVL [456]'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lars7]

Thanks PHV,
Haven't seen "not like" before, will use in future.