D
DOMIRICAN via AccessMonster.com
I have a problem with an error message.
The message I get is "the expression is typed incorrectly or too complex to
be evaluated"
It use to work before, not sure what happened!
HELP PLEASE!!!
PARAMETERS [forms]![PDate]![StartDate] DateTime;
TRANSFORM First(([se]/[downtime])) AS PP
SELECT ProductionQueryRpt.Department, ProductionQueryRpt.ProductionQueryRpt0.
Employee
FROM ProductionQueryRpt
WHERE (((ProductionQueryRpt.Active)=[Forms]![PDate]![active])) OR ((([Forms]!
[PDate]![active]) Is Null))
GROUP BY ProductionQueryRpt.Department, ProductionQueryRpt.
ProductionQueryRpt0.Employee, ProductionQueryRpt.Active
PIVOT "D" & DateDiff("d",Forms!PDate!StartDate,[PDate]) In ("d0","d1","d2",
"d3","d4","d5","d6")
WITH OWNERACCESS OPTION;
The message I get is "the expression is typed incorrectly or too complex to
be evaluated"
It use to work before, not sure what happened!
HELP PLEASE!!!
PARAMETERS [forms]![PDate]![StartDate] DateTime;
TRANSFORM First(([se]/[downtime])) AS PP
SELECT ProductionQueryRpt.Department, ProductionQueryRpt.ProductionQueryRpt0.
Employee
FROM ProductionQueryRpt
WHERE (((ProductionQueryRpt.Active)=[Forms]![PDate]![active])) OR ((([Forms]!
[PDate]![active]) Is Null))
GROUP BY ProductionQueryRpt.Department, ProductionQueryRpt.
ProductionQueryRpt0.Employee, ProductionQueryRpt.Active
PIVOT "D" & DateDiff("d",Forms!PDate!StartDate,[PDate]) In ("d0","d1","d2",
"d3","d4","d5","d6")
WITH OWNERACCESS OPTION;