I am trying to run a field in a query that returns a name if a certain product from another field equals a particular value. I am using the Iif function and the expression is as follows:
Taught By: IIf([Purchases]![Item Purchased]![Value]=2,[Purchases]![Pro/Staff Member Name]![Value], )," ")
So basically if the purchase item value is 2 then I want it to return the Pro/Staff Member Name or nothing. However when I run the query it returns the value instead of the name (the main table that it is coming from is 'Pros/Employees').
Any assistance would be greatly appreciated, thank you so much for your help!
Kelsey in Ohio
Please sign in to leave a comment.