I am using the below query to calculate sum of 4 variables in another field called Total. But I am getting the below syntax error. I am unable to understand the problem. Can any one take a look. Thank you in advance
IIf(IsNull([Entfernung_von_Dienststaette_km]), 0, [Entfernung_von_Dienststaette_km])
+ IIf(IsNull([Entfernung_von_Wohnung_km]), 0, [Entfernung_von_Wohnung_km])
+ IIf(IsNull([Weiterreise_vom_letzten_Reiseziel_km]), 0, [Weiterreise_vom_letzten_Reiseziel_km])
+ IIf(IsNull([Rueckfahrt_zur_Dienststaette_km]), 0, [Rueckfahrt_zur_Dienststaette_km])
+ IIf(IsNull([Rueckfahrt_zum_Wohnort_km]), 0, [Rueckfahrt_zum_Wohnort_km])
Syntax Error:
**The expression you entered contains invalid syntax.**
You may have entered an operand without an operator