Untitled
If UCase(Left(GetSystemSetting("RequireCallTypeToInvoice"), 1)) = "Y" Then strSQL = "SELECT ExportInvoiceList.InvoiceNumber AS InvoiceNumber " _ & "FROM ExportInvoiceList INNER JOIN Dispatch ON ExportInvoiceList.InvoiceNumber = Dispatch.InvoiceNumber " _ & "LEFT JOIN CallTypeList ON Dispatch.CallType = CallTypeList.CallType " _ & "WHERE ExportInvoiceList.Selected <> 0 AND ISNULL(CallTypeList.AccountNo,'') = ''"
Leave a Comment