Peter,

The same remark I gave you before, when you sue a constant to define a default it has to be the length and precision of the largest value that may be encountered. You use 0.00 in both selects, however is select 1 use the 0.00 for the first record it has a N(4,2) field in it, if the 2nd select uses a number that is 7,2 then its length is set that way and the two selects are not unionable.

Instead use 00000.00 with enough 0's to make it equal in length to the largest value.