Can I do his with the SQL I had created for the report, numerics of different lengths are also not compatible if I union two queries, I have to append 0000+fldname etc. to make them compatible.

I want to sum the numeric fields in the report.

Thanks for your reply

REgards
Bhavbhuti