>>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! :-)