SELECT GoldFedExTable.[Pickup Date] AS Expr1, Count(Nz([Ref 1],0)) AS [Number], Sum(GoldFedExTable.Charge) AS 7445
WHERE GoldFedExTable.[Ref 1] ="7445" OR GoldFedExTable.[Ref 1] IS NULL
GROUP BY GoldFedExTable.[Pickup Date];
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.