Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Criteria in CrosstabQuery
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.ListaDeDecor
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.
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.ListaDeDecor
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Nevermind that, solutionj was in front of me
PARAMETERS [Forms]![frmFScomposicao]!
TRANSFORM Max(MRodagem1.ListaDeDecor
SELECT MRodagem1.EQUIPA
FROM MRodagem1
WHERE (((MRodagem1.DATA) Between [Forms]![frmFScomposicao]!
GROUP BY MRodagem1.EQUIPA
ORDER BY MRodagem1.EQUIPA
PIVOT MRodagem1.producao.DATA;
PARAMETERS [Forms]![frmFScomposicao]!
TRANSFORM Max(MRodagem1.ListaDeDecor
SELECT MRodagem1.EQUIPA
FROM MRodagem1
WHERE (((MRodagem1.DATA) Between [Forms]![frmFScomposicao]!
GROUP BY MRodagem1.EQUIPA
ORDER BY MRodagem1.EQUIPA
PIVOT MRodagem1.producao.DATA;
<from 2 controls in a form, like a regular similar select query?>
just use the Name of form and control in the where clause and remove the Parameters
WHERE MRodagem1.DATA Between Forms!NameOfForm.NameofCon
just use the Name of form and control in the where clause and remove the Parameters
WHERE MRodagem1.DATA Between Forms!NameOfForm.NameofCon
Sorry Rey, i must be tired.... it was such a simple solution. Anyway its solved, These crosstabqueries are full of tricks!
Premium Content
You need an Expert Office subscription to comment.Start Free Trial