Search results

SELECT Movements.*, Customers.Location, Customers_1.Location FROM (Customers RIGHT JOIN Movements ON Customers.ID = Movements.FromCustomer) LEFT JOIN Customers AS Customers_1 ON Movements.ToCustomer = Customers_1.ID;

SELECT Received.Locale, Sum(Received.ID) AS SumOfdID, Received.MA, Received.Hue, Received.Gender, Count(IIf([Received]![Talla]="S",1)) AS S, Count(IIf([Received]![Talla]="L",1)) AS L, Count(IIf([Received]![Talla]="XS",1)) AS XS, Count(IIf([Received]![Talla]="M",1)) AS M...