I have two tables in which I keep Employee records one has direct employees the other contractors. They both have same field structure. I need to total count of records from both tables combined. These are remote tables an I access then with SPT.

I have tried UNION ALL but this gives me two records, the count from each table.