I am trying to check for fields that have missing foreign keys in my ExpensItems table. I can get an accurate count when I run a query using Is Null in the criteria for the CostAllocationCd field. Each of the attempts below returns #Error in the textbox control on my form.
Any suggestions would be appreciated. D. Carter