Access Form with PivotChart

[ricaforrica]

Hello!

I have a query, qryContract, which returns a list of software apps along with the start and end dates for the respective licensing contracts.

Then, I created the following Crosstab Query:

TRANSFORM Func(qryContract.StartDt,qryContract.EndDt)
SELECT qryContract.Soft
FROM qryContract
GROUP BY qryContract.Soft, Func(qryContract.StartDt,qryContract.EndDt)
PIVOT qryContract.Year In ("1998","1999","2000","2001","2002","2003","2004","2005","2006");

The results are something like this:

Software | 1998 | 1999 |...
-------------------------------------------------------
-------------------------------------------------------
Soft1 |01/01/1998-31/12/2000| x |...
-------------------------------------------------------
Soft1 |01/01/1998-31/12/1998|01/01/1999-31/12/1999|...
-------------------------------------------------------
Soft1 | x | x |...
-------------------------------------------------------
Soft1 | x |01/01/1999-31/12/1999|...
-------------------------------------------------------

So far so good!
What I'd really like is to create a chart with this info: for each software, a bar should be displayed if there is a contract for that year... I've been playing around with PivotChart, but I have no experience with that and the results are not the best!

Could you please help?
Thanks in advance,

Ricardo Pinto.