> SELECT COUNT(table1.field1) as t1;
> FROM dbtables!table1 WHERE table1.field1=somevarible into cursor; finalresults
>
>The variable condition is the same for all 3 tables. If someone can help me, I would appreciate it.
>
>TIA,
>Jim

select file1
count thisfield for thiscondition to variable1
select file2
count thisfield for thiscondition to variable2
select file3
count thisfield for thiscondition to variable3

GrandTotal = variable1 + variable2 + variable3