SELECT [Class] AS Customer, dds_Daily_Sales_Tb.Operations_Day AS [Transaction Date], [Store_Number] & "-" & [Date_Change] AS RefNumber, SortByRegion.QbStoreNumber AS Class, SortByRegion.SalesTax AS Item, dds_Daily_Sales_Tb.Total_Tax_Amount AS Price FROM DateChange INNER JOIN (SortByRegion INNER JOIN dds_Daily_Sales_Tb ON SortByRegion.[StoreNumber] = dds_Daily_Sales_Tb.Store_Number) ON DateChange.Invoice_Date = dds_Daily_Sales_Tb.Operations_Day GROUP BY dds_Daily_Sales_Tb.Operations_Day, SortByRegion.QbStoreNumber, SortByRegion.SalesTax, dds_Daily_Sales_Tb.Total_Tax_Amount, dds_Daily_Sales_Tb.Store_Number, DateChange.Date_Change HAVING (((dds_Daily_Sales_Tb.Operations_Day)=#6/1/2021#));
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.