Hi,
I have a crosstab query that always displays last 8 days worth of data(Date(),Date()-1,Date()-3, etc)).
Some of these columns are blanks and MS Access, by default, returns only those columns that has some values in it. How do I make sure that it displays even the blank columns with the dates in "yyyy/mm/dd" as column headers.My base query is like this.
I tried adding Date(),date()-1, etc in the Column headings in the properties, but no luck.
TRANSFORM IIf(Count([PQR Number]) Is Null,0,Count([PQR Number])) AS Expr2
SELECT [Closed Remedy PQR].[Report Category]
FROM [Closed Remedy PQR]
GROUP BY [Closed Remedy PQR].[Report Category]
PIVOT Format([Create-date],"yyyy/mm/dd");
.
Thanks,
Prasanna.