Hi John,

The only thing I can see, is you need to group both halves of the select statement.

select Field1, sum(Field2) from Table;
where Field3 ! = "XXX";
group by Field1;
union select Field1, sum(Field2) from Table2;
where Field3 ! = "XXX";
group by Field1

Try this.

HTH
Mike