I have a query which kind of shows a snapshot of current jobs in our system. some of those jobs have an "outsourced" component and some don't. I can get the query to show jobs that don't have an outsourced component or those that do, i just cant get it to show both at the same time. After reading a bit in help files and this forum and some books i believe the nz function could do this for me
Could someone explain to me what the nz function is and how to use it or suggest an alternative. Any help is greatly appreciated.