>>I understand what's being said, and have given another attempt. Does this look better? (I haven't tested it yet):
>
>Are you intending to sum up the bundle field in each datan table? If so this isn't going to do what you want.
>
>If you need the intermediate summations then you can do it in two steps.
>
>SELECT SUM( data1.bundle ) as sumvar FROM lumber!data1 into cursor bundata WHERE siz = szValue and grade = gdValue and length = 2 union all ;
>SELECT SUM( data2.bundle ) as sumvar FROM lumber!data2 WHERE siz = szValue and grade = gdValue and length = 2 union all ;
>SELECT SUM( data3.bundle ) as sumvar FROM lumber!data3 WHERE siz = szValue and grade = gdValue and length = 2 INTO CURSOR sums
>
>*!* Now you'll see one record with bundle summed for each of the selects
>*!* Now take the total
>
>SELECT SUM( sumvar ) FROM sums INTO CURSOR totalsum


why would this be telling me that "variable 'Total22' could not be found" in the tb2 = Total12 + Total22 +... statement?

SELECT data1.bundle as Total12;
FROM lumber!data1 into cursor bundata2;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data2.bundle as Total22;
FROM lumber!data2;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data3.bundle as Total32;
FROM lumber!data3;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data4.bundle as Total42;
FROM lumber!data4;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data5.bundle as Total52;
FROM lumber!data5;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data6.bundle as Total62;
FROM lumber!data6;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data7.bundle as Total72;
FROM lumber!data7;
WHERE siz = szValue and grade = gdValue and length = 2;
union all;
SELECT data8.bundle as Total82;
FROM lumber!data8;
WHERE siz = szValue and grade = gdValue and length = 2




tb2 = bundata2.Total12 + bundata2.Total22 + bundata2.Total32 + bundata2.Total42 + bundata2.Total52 + bundata2.Total62 + bundata2.Total72 + bundata2.Total82