I
inungh
I have a crosstab query and would like to have date as column heading.
The heading column needs to fixes even there is no even in the table.
For example the data as following:
"Activity Date", "Activity Code",
10/20/2008 A
10/23/2008 A
10/24/2008 B
I would like to have the result recordset as following:
10/20/2008, 10/21/2008, 10/22/2008, 10/23/2008, 10/24/2008
A 1 1
B
1
Since there is no activity on Oct/21 and Oct/22, there is no result
from result recordset for those days.
Are there any way to have Oct/21 and Oct/22 in the result set?
Your help is great appreciated,
The heading column needs to fixes even there is no even in the table.
For example the data as following:
"Activity Date", "Activity Code",
10/20/2008 A
10/23/2008 A
10/24/2008 B
I would like to have the result recordset as following:
10/20/2008, 10/21/2008, 10/22/2008, 10/23/2008, 10/24/2008
A 1 1
B
1
Since there is no activity on Oct/21 and Oct/22, there is no result
from result recordset for those days.
Are there any way to have Oct/21 and Oct/22 in the result set?
Your help is great appreciated,