Relative Date & Crosstab problem

[DOMIRICAN via AccessMonster.com]

I have a crosstab, when I put the normal date the information shows but when
I try to change it to a relative date, the query is empty and no values show.

HELP!!!!

PARAMETERS [forms]![PDate]![StartDate] DateTime;
TRANSFORM First(([SumOfEarned Hr]/([tpaid]-([sumofproject]+[sumofStation]+
[Brk])))) AS PP
SELECT ProductionQueryRpt.Department, ProductionQueryRpt.ProductionQueryRpt0.
Employee
FROM ProductionQueryRpt
WHERE (((ProductionQueryRpt.Active)=[Active: Enter Yes or leave blank for all]
))
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","D7")
WITH OWNERACCESS OPTION;

 

[Guest]

What results do you get when you remove the column headers string from the
query?

IN ("D0", .....)

 

[DOMIRICAN via AccessMonster.com]

Amazingly it all worked out. I guess my computer was tired yesterday. I
didn't change anything and the info does appear today. I will check tomorrow
and see if my story changes. Thanks for your quick response.

What results do you get when you remove the column headers string from the
query?

IN ("D0", .....)

I have a crosstab, when I put the normal date the information shows but when
I try to change it to a relative date, the query is empty and no values show.

[quoted text clipped - 14 lines]

"D3","D4","D5","D6","D7")
WITH OWNERACCESS OPTION;