• You need to do an outer join with a table that contains all dates on which you want to report.

    Check this topic for some inspiration.

    Regards,

    Willem
    http://wschampheleer.wordpress.com[/url]