multiple fields on report

[cargan]

I have a report which takes data from a database table which has more than one row for the same reference no.
i.e. staff no 1 can have rows with a status code of COM, MGTWRK, NSHOW and others. I want to report on staff who do not have a status code of COM but I also want to only list them once no matter how many other records they have on the table. Can anyone suggest a means to do this ?

Thanks.

 

[AndrewBaines]

Group on staff ID. Have a formula that joins all their status codes together, display the formula in the group footer with the staff ID.
For the selection, use a group selection along the lines of WHERE not(staffCodes contains 'COM') or whatever the syntax works out as. Andrew Baines
Chase International