I wonder if you can help please?
I've got four columns on a report (Tutors 1 and 2 from two different tables) that I need to check if they match. I've written a formula to check if the Tutor 1 fields match and the formula works correctly. However, when I try and create the same formula to check the Tutor 2 fields the formula is set correctly until I enter ENDIF, when it then deactivates the formula and creates a parse error when I run the report:
I don't know what is causing the formula to be deactivated, as it is recognising the fields I want to reference and the values to show if they match or not, and if I don't put ENDIF I get a "Malinformed if statement" error. I've used the formula function to ensure the gaps and wording is correct so am stumped as to why the formula is deactivated - any help would be gratefully received!
