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