If field is null....???

T

TechTutors

I would like to use the query to perform the following:

If [fieldA] is null... then get the data from [fieldZ]

Any help would be greatly appreciated ... thanks!
 
F

fredg

I would like to use the query to perform the following:

If [fieldA] is null... then get the data from [fieldZ]

Any help would be greatly appreciated ... thanks!
Click to expand...

NewColumn:IIf(IsNull([FieldA]),[FieldZ],[FieldA])
 
J

John W. Vinson

I would like to use the query to perform the following:

If [fieldA] is null... then get the data from [fieldZ]
Click to expand...

NZ([FieldA], [FieldZ])

John W. Vinson [MVP]
 
Top