P
prasanna.janardhana
Hi,
I came up with this crosstab query which gives 8 days worth of
data.However, if
my database has only 6 days of data and 2 days in between are blank,
this query
just ignores those two days and displays only 6 days.
I have attached my code and output in here.
How can I change this to display blank fields as well?
Please help,
Thanks,
Prasanna.
sSQL = " TRANSFORM Count([Open Remedy PQR].[PQR Number]) AS
[CountofPQR] " & _
" SELECT [Open Remedy PQR].[Report Category]," & _
" Count([Open Remedy PQR].[PQR Number]) AS [Total of PQR Number]" & _
" FROM [Open Remedy PQR] " & _
" WHERE ([Report Category] <> '[Not Reported]'" & _
" AND ([Create-date] >= DATEADD('d', -8,Date() )))" & _
" GROUP BY [Report Category] " & _
" PIVOT Format([Create- date],'yyyy/ mm/dd');"
I came up with this crosstab query which gives 8 days worth of
data.However, if
my database has only 6 days of data and 2 days in between are blank,
this query
just ignores those two days and displays only 6 days.
I have attached my code and output in here.
How can I change this to display blank fields as well?
Please help,
Thanks,
Prasanna.
sSQL = " TRANSFORM Count([Open Remedy PQR].[PQR Number]) AS
[CountofPQR] " & _
" SELECT [Open Remedy PQR].[Report Category]," & _
" Count([Open Remedy PQR].[PQR Number]) AS [Total of PQR Number]" & _
" FROM [Open Remedy PQR] " & _
" WHERE ([Report Category] <> '[Not Reported]'" & _
" AND ([Create-date] >= DATEADD('d', -8,Date() )))" & _
" GROUP BY [Report Category] " & _
" PIVOT Format([Create- date],'yyyy/ mm/dd');"