If field is null....???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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])
 
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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query about query of subtracting 2 fields 2
Populate entire field in query with the value of a cell 6
Update of a field conditionally on another field in the same table 4
if null or zero 9
#error - Blank 3
How to hide a control on a different tab [page] of a form? 5
Populate a field in a query with the value of record 4
One Field splits to four fields 4

Back
Top