Well, I've tried several ways but I can't display anything in a tabular fashion on here... so I don't know how to make this make sense. The following was my final attempt to show the data but I don't know how to get this forum to show table, can't get spaces to hold their space for freeform... sorry. If you paste each of these html box contents into a notepad doc and name it .html and open it you can see what I mean.
No, I'm not explaining this correctly. What I have is a CrossTab query that looks like this on output:
HTML Code:
<TABLE>
<tr>
<td></td>
<td>Emp1</td>
<td>Emp2</td>
<td>Emp3</td>
<tr>
<tr>
<td>3/1/11</td>
<td>1</td>
<td></td>
<td>1</td>
<tr>
<tr>
<td>3/17/11</td>
<td></td>
<td>1</td>
<td></td>
<tr>
<tr>
<td>4/01/11</td>
<td></td>
<td></td>
<td>1</td>
<tr>
</TABLE>
Which is showing:
both Emp1 and Emp3 have 3/1/11 off (this functionality is the whole point to the exercise)
Emp2 has 3/17/11 off
Emp3 has 4/01/11 off
The problem I am trying to solve is that the dates shown are start dates. In actuality Emp2 has startdate of 3/17/11 thru endadate of 3/19/11 off. I have the end date available to work with but don't know how to display:
HTML Code:
<TABLE>
<tr>
<td></td>
<td>Emp1</td>
<td>Emp2</td>
<td>Emp3</td>
<tr>
<tr>
<td>3/1/11</td>
<td>1</td>
<td></td>
<td>1</td>
<tr>
<tr>
<td>3/17/11</td>
<td></td>
<td>1</td>
<td></td>
<tr>
<tr>
<td>3/18/11</td>
<td></td>
<td>1</td>
<td></td>
<tr>
<tr>
<td>3/19/11</td>
<td></td>
<td>1</td>
<td></td>
<tr>
<tr>
<td>4/01/11</td>
<td></td>
<td></td>
<td>1</td>
<tr>
</TABLE>
That's what I am trying to achieve. To have all the dates between startdate and enddate to display as row headings for the crosstab.
Hopefully that is clearer? Thanks for your help and your patience!