scgoodman
03-24-2009, 03:50 PM
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?
|
View Full Version : Error in Dateadd 'h' scgoodman 03-24-2009, 03:50 PM 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 03-24-2009, 03:51 PM Use the NZ function. scgoodman 03-24-2009, 03:58 PM Can you elborate on this? NZ function... This is what I have built: DeliveryDueDate: DateAdd("h",[TurnaroundTime],[ReceivedDate] boblarson 03-24-2009, 06:27 PM 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])) |