I am trying to create a report that excludes certain data based on the value of another field. Basically this is what I need to do. The report is for company wide surveys and is sent to upper level managers. For instance I want to send the Adminstrators all employees survey results with the exception of a few answers of those employees directly below them. I don't want the supervisors to see the ratings given by their employees directly below them regarding their supervisors performance. I know I will have to change this formula based on who the supervisor is however I have hit a snag with having these fields return a nul value. I know this formula is not correct and probably way off however i'm in need of some help. I'm using CR10 and Access is my database for this report. Please see a this sample formula
If{TBL_Team_Departments.Reports_to}="Joe Zaczyk" then {TBL_MASTER_Team_Survey_Data.Q1_Supervisor_S}and{TBL_MASTER_Team_Survey_Data.Q1_Supervisor_C}=nul
If{TBL_Team_Departments.Reports_to}="Joe Zaczyk" then {TBL_MASTER_Team_Survey_Data.Q1_Supervisor_S}and{TBL_MASTER_Team_Survey_Data.Q1_Supervisor_C}=nul