I have a from in which I'm trying to pull a report on a single employee listing total possible scores for each section of the audit. I have 2 empl fields because 2 different employees can be audited on 2 parts of the process on the same form. EmployeeN (drop down list) and then Empl2Name (data entry which should mirror the drop down list). When creating query I can pull the EmployeeN field but pulling data for second emp with only the same name I can't do. How do I create a query that will look at the Empl2Name and see if it matches or is = to EmployeeN so I Pull data from both audits for only that employee name? The audit form has 2 tabs (the first audit) and then for the 2nd audit. I use AuditID (AudtoNumber)to ID each form and each form has 2 part to the audit. I tried an IIF statement =iif([Empl2Name]=[EmployeeN],[Empl2Name],0) but that didn't work. I need total Possible Scores to show for both sections n ref to that empl only.
Thanks,
Dedicated
Thanks,
Dedicated