What kind of field is Building? What data type is defined and what data entry methods are used to enter a value? (If it's a check box group, you will need a different expression.)
BTW: Building = "Langley" will also return a 1, you don't need the If function here.
Building is a text field with a value list.
I just tried this, maybe you can explain.
I changed the calculation to Langley=If ( Building="Ignatia"; 1) and entered Ignatia in the building field and it works. When I changed the calculation back to thew origianal, and placed Langley in the building field, it no longer works.
What kind of value list? Checkbox group? or ?
A drop down list of custom values. and I have checked, it is spelled correctly in the value list and calculation.
I'd check for any invisible characters such as a space or return character in the field and/or value list.
You might try playing with the trim and patterncount functions to see if they make a difference:
Trim (Building) = "Langley"
will remove leading and trailing spaces.
PatternCount ( Building ; "langley" )
will return a nonzero (true) result even if there are other non visible characters before or after the quoted text.
Not sure how the best answer got checked, still trying to figure this one out.
I tried changing it to an edit box, and manually typing it in, and still nothing. All of the other calculations work correctly off of this field except for 3, and they are done in the exact same manner except the value being looked for.
When you check the field in Manage | database | fields, is it of type text? (I would think so given that your test with "Ignatia" worked, but let's be sure here.)
Ok.... I figured it out.. With your help.... He had entered Langley in the value list and origianally had it as Langley St., and when he changed it to just Langley, he still had the space in the value list.
I was racking my brain on this......