>
>You may use UNION here:.... >
>Thanks, both yours and Garrett's suggestions gave me exactly the same result
>set, the one difference being his with .NULL. values, and yours with blank and
>zero values in the date-total-earned fields.
There's more than one way to skin a Fox! :-)