Untitled

avatar
unknown
plain_text
10 months ago
450 B
2
Indexable
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,'') = ''"
Editor is loading...
Leave a Comment