Liveware Publishing Support Forum

I have some reports that involve calculating from a date field in Excel using the ADDYRS or IIF function. In some cases the excel field is empty resulting in the string of ****. I have tried using the "ERROR" function to no avail. The only way I have been able to subsitute a text entry for...

That seemed to do the trick, thanks. Having been a R&R user and enthusiust since version 1 this has been my first attempt to work with excell files. What I also didn^t pickup on was that R&R was referenceing the workbook name, not the file name.

I^m running R&R SQL v9 (with the latest patch) under W2K and am trying, with no success, to access Excell 2002 files without saving them first as dbf files. When installing R&R I selected excell drivers. As data source I select excell files but and select the directory but the end result is ...