This might be a very simple question but i don't know why i'm having trouble with this, i have a report where i have a cost center example 99999 and within that cost center i have employes 1 through 5.

I would like to create a report where i output costcenter 99999 and not include employee 4

WHERE ( COSTCENTER EQ '99999') AND ( jobcode NE '4' );

This message has been edited. Last edited by: <Kathryn Henning>,

This looks right, but also depends on your data structure as well.

Have you tried it ?

Hi Waz,

After just looking at the report again i found the issue, the error was not the where clause it was the field i was looking at. There is a case set on that field and it populates a value based on a certain criteria.

This is resolved now Thank you

Please edit the first post in this thread and add [SOLVED] or [CLOSED] to the title.