Need to use the ACCESS query, need according to the following requirements of output data: according to the time & amp; , to make the number sum & amp; Bar code count (order statistics) & amp; Barcode count (don't repeat count, statistical SKU)

Now finally a repeat count not don't know how to deal with,

Also please teach great god ~ ~

SQL source:

SELECT [B2B outbound data summary]. Date, stores. Stores, the Sum () [r]. B2B outbound data aggregation number) AS the number of aggregate, the Count ([B2B outbound data summary]. Bar code) AS the counting of bar code, the Count ([B2B outbound data summary]. Bar code) AS barcode counting 1
The FROM [B2B outbound data summary] INNER JOIN stores summary ON [B2B outbound data summary] number=the summary store. Stores,
GROUP BY [B2B outbound data summary] date, stores. Stores;

Data table artwork: