Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
select distinct LOAD.LOAD ,LOAD.WEIGHT as LOAD_WEIGHT ,LOAD.cube as LOAD_CUBE ,FORMAT(LOAD.PERCENTFULL, '0.00') AS PENCENTAGE_FULL ,LOAD.TRIP ,LOAD.TRAVELEDDISTANCE ,LOAD.CARRIER ,LOAD.SERVICE ,MID(stop.location, INSTR(1, stop.location, ',') + 1, INSTR(INSTR(1, stop.location, ',') + 1, stop.location, ',') - INSTR(1, stop.location, ',') - 1) AS LOCATION ,LOC_AND_HIB.CITY ,LOC_AND_HIB.STATE ,STOP.DISTANCEFROMLAST ,stop.sequence AS SEQUENCE ,PICK_DROP.PICKDROP ,SHIPMENT.SHIPMENTID ,SHIPMENT.COMMODITYCODE ,SHIPMENT.WEIGHT as ORD_WEIGHT1 ,SHIPMENT.cube as ORD_CUBE1 ,SHIPMENT.PIECES AS ORD_PIECES ,SHIPMENT.SKIDS as ORD_PAL FROM ( ( Pick_Drop INNER JOIN Shipment ON Pick_Drop.ShipmentID = Shipment.ShipmentID ) INNER JOIN ( ( LOAD INNER JOIN Stop ON LOAD.LOAD = Stop.LOAD ) INNER JOIN loc_and_hib ON Stop.Location = loc_and_hib.LocationID ) ON (Pick_Drop.LOAD = LOAD.LOAD) AND (Pick_Drop.Sequence = Stop.Sequence) ) order by LOAD.LOAD ,stop.sequence;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access Why is my list box VBA code seem to be one number off?||2||25|
|Problem with MySQL query - graph||3||23|
|Trying to export a table to another Access database file||2||15|
|Turning off query prompts on runtime version of Access 2016||5||17|