Syntax help

[matthewR]

I have the following. Not sure if my syntax is correct.

IIF ([Current District] <> [Baseline District], [Current District] or IIF[Current District] is null,[Baseline District], [Current District])

[HansV]

Does this do what you want?

Nz([Current District], [Baseline District])

[matthewR]

There are two different scenarios - current District and baseline District are two different names - I want Current. If Current is null, I want baseline. Will that formula cover this or am I making this harder than it is?

[HansV]

NZ(a, b) will return a unless a is Null, then it will return b. So Nz([Current District], [Baseline District]) will return [Current District], unless that is Null, then it will return [Baseline District].

[matthewR]

Thanks Hans. That worked fine.