I have made a query with this expression in a column:

Hardware_RetireDate: DateAdd("yyyy",[Hardware_WarrantyLength],[Hardware_PurchaseDate])

It adds the Hardware_WarrantyLength to the Hardware_PurchaseDate.

However, if there is no number in the "Hardware_WarrantyLength" field there is an "#Error" message in the "Hardware_RetireDate" field.

Does anyone know how to get rid of the "#error" text (without having to leave the WarrantyLength as "0", like I am doing at the moment)

Thanks a lot