P
Prasanna
Hi,
I m newbie to sql. I use Access interface alot. I wanted to display last 8
days of data on crosstab query. However, the column headers are missing if
the data is not available. My query is here:
TRANSFORM Count([Closed Remedy PQR].[PQR Number]) AS [CountOfPQR Number]
SELECT [Closed Remedy PQR].[Report Category], Count([Closed Remedy PQR].[PQR
Number]) AS [Total Of PQR Number]
FROM [Closed Remedy PQR]
WHERE ((([Closed Remedy PQR].[Create-date])>Date()-8))
GROUP BY [Closed Remedy PQR].[Report Category]
PIVOT Format([Create-date],"yyyy/mm/dd");
I tried adding the column headers on right-click ---> properties. I typed in
date(),date()-1, etc. but no luck.
Thanks,
Prasanna.
I m newbie to sql. I use Access interface alot. I wanted to display last 8
days of data on crosstab query. However, the column headers are missing if
the data is not available. My query is here:
TRANSFORM Count([Closed Remedy PQR].[PQR Number]) AS [CountOfPQR Number]
SELECT [Closed Remedy PQR].[Report Category], Count([Closed Remedy PQR].[PQR
Number]) AS [Total Of PQR Number]
FROM [Closed Remedy PQR]
WHERE ((([Closed Remedy PQR].[Create-date])>Date()-8))
GROUP BY [Closed Remedy PQR].[Report Category]
PIVOT Format([Create-date],"yyyy/mm/dd");
I tried adding the column headers on right-click ---> properties. I typed in
date(),date()-1, etc. but no luck.
Thanks,
Prasanna.