Error in Dateadd 'h'

[scgoodman]

Trying to do a dateadd in hours in access and if one of the fields that needs to be populated to calculate this field is not populated I get an #Error message. How can I just show this as blank?

 

[boblarson]

Use the NZ function.

 

[scgoodman]

Can you elborate on this? NZ function...

This is what I have built:

DeliveryDueDate: DateAdd("h",[TurnaroundTime],[ReceivedDate]

 

[boblarson]

Actually, perhaps that isn't the best as it would return a very ancient date. I think you would probably go for this instead:

DeliveryDueDate: IIf(IsNull([ReceivedDate]),"",DateAdd("h",[TurnaroundTime],[ReceivedDate]))