Torna al Thread
PARAMETERS prmAnno Short, prmStagione Short, prmZona Short, prmZonaFin Short, prmAge Short, prmAgeFin Short, prmData DateTime, prmSelZona Short;
SELECT Ordini.Cliente
FROM Ordini
WHERE (((Ordini.DesNum30)<>IIf([prmSelZona]=3,'EST',IIf([prmSelZona]=4,'ITA',' '))) AND ((Ordini.Anno)=[prmAnno]) AND ((Ordini.Stagione)=[prmStagione]) AND ((Ordini.DataOrdine)<=[prmData]) AND ((Ordini.Zona)=[prmZona] Or (Ordini.Zona)>=[prmZonaFin]) AND ((Ordini.Agente)=[prmAge] Or (Ordini.Agente)>=[prmAgeFin]))
GROUP BY Ordini.Cliente;