Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Problem for Multiple Name Fields

Status
Not open for further replies.

Dedicated

Programmer
Dec 26, 2003
38
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top