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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:email@example.com
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: