I have been searching the internet to help solve what seems to be a relatively common error. I created an Access module to calculate Networking days between two dates. Then I set up a query so that I could use the module/code however if one of my date fields is blank I get a #error message in the query. Is there a way to change the #error message to be a 0 or N/A? I saw this question posted but I couldn't find the response. BTW - I am using MS Access 2002 Any help would be greatly appreciated!