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>,
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.