Skip to Content
Former Member
Apr 25, 2007 at 02:46 AM

show missing fields


Post Author: DMUNOZ

CA Forum: General

Hello everyone, I am fairly new to cr9 and I need to build a report that will show me all of the missing events for each employee. Examples of the two tables I have with the fields are listed below. Right now I have a left join link from Events PersonIDNo to EmployeePersonIdNo but all it gives me is the Events they already have. I have tried writing an ISNull Formula but that does not work it because it will only say false for the events that are in place but it will not show me the missing events any help will be much appreciated.

Events Employee

PersonIdNo PersonIdNo

EventCodeIdNo FullName

EventCodeType Person TaxIDNO