1 2 3
| SELECT Sheet1.[Pegged Quantity], Sheet1.Points, Sheet1.Name, Sheet1.City, Sheet1.[Ship To Party], Sheet1.[Sales Organization], Sheet1.Choose, Sheet1.[Purchase order no#], Sheet1.[Order Quantity], Sheet1.[Confirmed Quantity], Sheet1.[Sales Document], Sheet1.[Sales Document Item], Sheet1.[Points per line (Pegged)], Sheet1.Description, Sheet1.[Requested deliv#date], Sheet1.[Delivery Date], Sheet1.[Arrival time], Sheet1.[Delivery Block Header], Sheet1.[Delivery Block Sched# Line], Sheet1.[Tail Lift], Sheet1.Pallets, Sheet1.[Gross weight], Sheet1.Material, Sheet1.[Telephone 1], Sheet1.[Postal Code], Sheet1.[Purchase order no#1], Sheet1.[Document Date], [Delivery Block Header] & +[Delivery Block Sched# Line] AS block, Sheet1.datepegged, Format([datepegged],"\ mmmm") AS [Mois pegged], Date() AS Ladatedujour, DateDiff("j",[Document Date],[datepegged]) AS jourss, DateDiff(" j",[Document Date],Now()) AS [Clients depuis], [Work_Days] AS VBA
FROM Sheet1
WHERE (((Sheet1.[Pegged Quantity])>0) AND (([Delivery Block Header] & +[Delivery Block Sched# Line]) Is Not Null)); |
Partager