Ok I’m having trouble with this simple calculation.
I have a Query with a field called “% of fire Calls made” it may contain a number (ie 23.34). I’ve tried to create another field in the same query that ask the question, if the # in “% of fire Calls made” is equal to or greater than 10, I then want the new field to say 25.
This is the field as it reads after I tried using the expression builder: Points for fire calls: IIf([% of fire Calls made]>=10,"25")
I keep getting an error that reads Syntax error in the query expression ‘IIf(% of fire Calls made>=10,“25”)’.
I have also looked at the book and i can't find what I'm doing wrong. Any help would be greatly appreciated
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!