Issue with an Iif statement in a query
CompletedHello,
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:
I want to find where to buy delta8 tetrahydrocannabinol or delta-8 tetrahydrocannabinol, is it available where to buy delta 8 near me? This was my question when I read about delta-8 THC. When I found out that it is available in California, I was so happy because I really needed this product and I couldn't afford to buy anything else.
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').
Please sign in to leave a comment.
Comments
1 comment