Hello Fellows
My questions is:
Is it possible to do the criteria to this crosstabquery
PARAMETERS [Data de Inicio] DateTime, [Data de Fim] DateTime;
TRANSFORM Max(MRodagem1.ListaDeDecores) AS MaxOfListaDeDecores
SELECT MRodagem1.EQUIPA
FROM MRodagem1
WHERE (((MRodagem1.DATA) Between [Data de Inicio] And [Data de Fim]))
GROUP BY MRodagem1.EQUIPA
ORDER BY MRodagem1.EQUIPA
PIVOT MRodagem1.producao.DATA;
from 2 controls in a form, like a regular similar select query?
Thanks in advanced.
Greetings.
just use the Name of form and control in the where clause and remove the Parameters
WHERE MRodagem1.DATA Between Forms!NameOfForm.NameofCon