Writing a expression

[nrhodes00]

Hi - I'm writing a report but i need help writing a what if expression.

Here is what I'm trying to do:
I have 2 columns one is called Coverage Option Code and the another is called Relationship code
1 -Create a query calculation and call it Coverage Option Code 2 (already know how to do that)
2 - In the new column i what the expression to say if Coverage Option Code is 'EECH' and the relationship code is 'SP' then make the result be NO CVG.

I'm stuck and don't know what the expression should be I'm hoping there is one out there

Nellie

[MFGF]

if ([Coverage Option Code] = 'EECH' and [Relationship Code] = 'SP') then ('NO CVG') else ([Coverage Option Code])

I assumed that for all other instances than the specified condition you would want to see the value of the Coverage Option Code displayed?  If this is not the case, either replace it with the relevant item to display, or change the end of the expression to be   else (null)   to display nothing.

Hope this helps! :-)

MF.

[nrhodes00]

thanks that worked