SELECT dbo_tblDTFInvoice_test.txtINVOICENUM AS INVOICENUM,
 dbo_tblDTFInvoice_test.txtCARRIERID AS CARRIERID,
 dbo_tblDTFInvoice_test.txtCARRIERNAME AS CARRIERNAME,
 dbo_tblDTFInvoice_test.txtCARRIERACCTNUM AS CARRIERACCTNUM,
 Format([dteDATAENTDTE], "mm-dd-yyyy") AS DATAENTRYDATE,
 Format([dteINVOICEDTE], "mm-dd-yyyy") AS INVOICEDATE,
 Format([dteMONTHPAID], "mm-dd-yyyy") AS MONTHPAID,
 dbo_tblDTFInvoice_test.memCOMMENT AS COMMENT,
 dbo_tblDTFShipInfo_test.txtAWBNUM AS AWBNUM,
 Format([dteIMP/EXPENTDTE], "mm-dd-yyyy") AS SHIPDATE,
 Format([dteIMP/EXPENTDTE], "mmmm yyyy") AS MONTHPROCESSED,
 dbo_tblDTFShipInfo_test.txtSHIPTYPE AS SHIPTYPE,
 dbo_tblDTFShipInfo_test.numTOTALCHGS AS TOTALCHGS,
  dbo_tblDTFShipInfo_test.txtDESTNZIP AS RECIPIENTZIP,
 dbo_tblDTFShipInfo_test.numWEIGHT AS WEIGHT,
 [numTOTALCHGS]/[numWEIGHT] AS CostPerPound,
 dbo_tblDTFShipInfo_test.txtSERVICETYPE AS SERVICETYPE,
 dbo_tblDTFShipInfo_test.txtCOSTCENTER AS COSTCENTER,
FROM dbo_tblDTFInvoice_test 
INNER JOIN dbo_tblDTFShipInfo_test ON dbo_tblDTFInvoice_test.txtINVOICENUM = dbo_tblDTFShipInfo_test.txtINVOICENUM
ORDER BY dbo_tblDTFInvoice_test.txtINVOICENUM;