Hello All,
Hoping you can help with this query problem I am having.
Currently running this query:
SELECT UPSTrackingNumbers.TenderedToDriver, UPSTrackingNumbers.ShipDate, UPSTrackingNumbers.POD, UPSTrackingNumbers.ShippingMethod, UPSTrackingNumbers.VoidIndicator, OrderDetails.ProductCode, OrderDetails.ProductName, Orders.DamagedInTransit, UPSTrackingNumbers.PackageNegotiatedRatesCharge, Orders.Cancelled, Orders.Rep, Orders.AmazonEbayOrderID, Orders.EarliestShipDate, UPSTrackingNumbers.StatusCode, UPSTrackingNumbers.StatusDate, UPSTrackingNumbers.StatusDescription, UPSTrackingNumbers.ShippingService, UPSTrackingNumbers.TrackingNumber, UPSTrackingNumbers.ShippingMethod, UPSTrackingNumbers.Damaged, UPSTrackingNumbers.Delivered, UPSTrackingNumbers.DeliveredDate, UPSTrackingNumbers.TenderedToDriverDate, Orders.DamagedInTransit, Orders.PackedBy
FROM (UPSTrackingNumbers INNER JOIN Orders ON UPSTrackingNumbers.OrderNo = Orders.OrderID) LEFT JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID
WHERE (((UPSTrackingNumbers.ShipDate) > DateAdd("d", -30, Date())) And ((UPSTrackingNumbers.POD) Is Null) And ((UPSTrackingNumbers.VoidIndicator) <> "Y") And ((UPSTrackingNumbers.StatusCode) = "OC") And ((UPSTrackingNumbers.ShippingMethod) = "FedEx") And (Orders.Cancelled = 0) And (Date() > Orders.EarliestShipDate))
ORDER BY UPSTrackingNumbers.TenderedToDriver DESC , UPSTrackingNumbers.ShipDate DESC;
Which gives the result:
TenderedToDriver ShipDate POD Expr1003 VoidIndicator ProductCode ProductName Expr1007 PackageNegotiatedRatesCharge Cancelled Rep AmazonEbayOrderID EarliestShipDate StatusCode StatusDate StatusDescription ShippingService TrackingNumber ShippingMethod Damaged Delivered DeliveredDate TenderedToDriverDate DamagedInTransit PackedBy No 1/30/2023
FedEx N COM-132 Quality Chemical Oven & Grill Cleaner Heavy-Duty / Fast acti No $25.77 No Amazon 111-0698114-7605063 01/30/2023 OC 01/30/2023 Shipment information sent to FedEx FEDEX_PTP_HOME_DELIVERY 394010384140 FedEx No No
No Amelia No 1/30/2023
FedEx N QCC-132-4 Oven & Grill Cleaner Heavy-Duty/High Power! Nothing Stronger No $25.77 No Amazon 111-0698114-7605063 01/30/2023 OC 01/30/2023 Shipment information sent to FedEx FEDEX_PTP_HOME_DELIVERY 394010384140 FedEx No No
No Amelia
How can I limit the result to give just one distinct tracking number. If you notice, the tracking number [394010384140] is repeated twice.
Thank you in advance!