Difficult Cross-Tab

[oli4o]

I have the following data:

RecNo | DateFrom | DateTo | Code
1 4/1/06 4/3/06 A
2 4/2/06 4/2/06 A
3 4/7/06 4/7/06 A
4 4/20/06 4/20/06 B


I need a crosstab that displays all dates that have a code in them within a choosable range (i.e. 3/1/06 to 5/1/06 or 1/1/06 to 12/1/06)
The row (or column) would show the Codes (like A, B)
The cells show number of times the code appears.

The problem is, that Code A from RecNo 1 has to be counted for 4/1, 4/2 and 4/3 as one entry
And then on 4/2 there is another Code A from RecNo 2

This would be the resulting cross-tab:

4/1 4/2 4/3 4/7 4/20
A 1 2 1 1
B 1

Thanks in Advance

Olivier