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
June 10, 2010 2:21 PM
September 22, 2010 7:52 PM