can somebody help me with my sql. im sort of new to
vb...
sql = "SELECT TBL_INVOICE.INVOICE_NUMBER, TBL_INVOICE.PO_NUMBER, TBL_INVOICE.RECEIVING_DATE, TBL_INVOICE_ITEMS.ITEM_ID, TBL_ITEM_DESC.ITEM_DESC, TBL_INVOICE_ITEMS.ITEM_QTY, TBL_INVOICE.RECEIVED_BY, TBL_INVOICE.PO_RELEASE_NO " & _
"FROM TBL_INVOICE INNER JOIN (TBL_INVOICE_ITEMS INNER JOIN TBL_ITEM_DESC ON TBL_INVOICE_ITEMS.ITEM_ID = TBL_ITEM_DESC.ITEM_ID) ON TBL_INVOICE.INVOICE_NUMBER = TBL_INVOICE_ITEMS.INVOICE_NUMBER " & _
"WHERE (((TBL_INVOICE.RECEIVING_DATE) Between [@'" & dfrom & "'] And [@'" & dto & "']) AND ((TBL_INVOICE_ITEMS.ITEM_ID) Not Like "*NS*"))" & _
"ORDER BY TBL_INVOICE.RECEIVING_DATE, TBL_INVOICE.PO_NUMBER;"
thanx in advance...