Hello Yuri,
>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.
Randy Bosma
VFP - Because life is too short to code in something else...