I wonder if anyone can help.
I am running a simple query that adds a number of numerical fields together.
The Expression Builder looks similar to this:
qu96-98: [tblMSCL]![MSCL_Q096]+[tblMSCL]![MSCL_Q097]+[tblMSCL]![MSCL_Q098]
The kind of data would look like this in real terms:
2+2+99
What I want to do is get the experession to ignore any values that are a certain number (in this case 99). So I want the answer displayed to be 4 NOT 103
The problem I'm having is that if [tblMSCL]![MSCL_Q096] contains a value I don't want included I can't work out how to say 'just ignore that one value, don't ignore the whole row'.
Any suggestions??
Rachel