Query used to import data from access > excel

[Perceptus]

I have a query that I have been using for a few months that has worked great. Recently I have been getting an error that says there was a problem with the database or server. I have found that the problem lies in the field in the query that does



IIf(IsDate([tblSalesOrders].[DatePromised]),CInt(CDate([tblSalesOrders].[DatePromised])-Now()),"") AS days_until_due

When I remove that from the query, the query returns data to excel.

Thoughts?

[Perceptus]

found my problem, had a pesky null in datepromised for 1 line ....

thanks anyways.