Update field with another if empty only in the query

[janschutz]

I am creating a query that is showing early / late delivery on Purchase
Orders. The problem is the request date is always filled in but the promise
date is sometimes blank. What is the best way to fill in the promise date
with the request date if the promise is blank.

Thanks for all your help.

 

[David Cox]

In query design view, something like:

Promised Date: IIF([Promise date]="",[Request date],[Promise date])


"[email protected]"

 

[janschutz]

David

I typed in the info listed below but the response from the query was an
#error message in the cell that was created if it had data before or if it
was blank the cell is still blank.

Could this be because it is formated as a date cell?

In query design view, something like:

Promised Date: IIF([Promise date]="",[Request date],[Promise date])


"[email protected]"

I am creating a query that is showing early / late delivery on Purchase
Orders. The problem is the request date is always filled in but the
promise
date is sometimes blank. What is the best way to fill in the promise date
with the request date if the promise is blank.

Thanks for all your help.

 

[David Cox]

sorry, try:

Promised Date: IIF(isnull([Promise date]),[Request date],[Promise date])



"[email protected]"

David

I typed in the info listed below but the response from the query was an
#error message in the cell that was created if it had data before or if it
was blank the cell is still blank.

Could this be because it is formated as a date cell?

In query design view, something like:

Promised Date: IIF([Promise date]="",[Request date],[Promise date])


"[email protected]"

I am creating a query that is showing early / late delivery on Purchase
Orders. The problem is the request date is always filled in but the
promise
date is sometimes blank. What is the best way to fill in the promise
date
with the request date if the promise is blank.

Thanks for all your help.

 

[janschutz]

That worked, thanks for all your help. The quick responce was also very
nice. : )

sorry, try:

Promised Date: IIF(isnull([Promise date]),[Request date],[Promise date])



"[email protected]"

David

I typed in the info listed below but the response from the query was an
#error message in the cell that was created if it had data before or if it
was blank the cell is still blank.

Could this be because it is formated as a date cell?

In query design view, something like:

Promised Date: IIF([Promise date]="",[Request date],[Promise date])


"[email protected]"
I am creating a query that is showing early / late delivery on Purchase
Orders. The problem is the request date is always filled in but the
promise
date is sometimes blank. What is the best way to fill in the promise
date
with the request date if the promise is blank.

Thanks for all your help.