Formula to determine if specific data exists in a linked table
I have a report that pulls a gift summary and need to split totals between employees and nonemployees by determining if an "Employee" code exists in a Constituency table containing multiple entries for each donor. My Donor table is linked to the Constituency table with a left outer join. I've been able to get the right information in the report body using groups and summary tools, but ran into trouble when trying to transfer the summarized field to a cross tab. How can I set up a formula that returns a single yes/no answer for each record in my Donor table so I can use that field in the cross tab?