>>It also looks like he has a blank line after each select statement, and each select statement has a continue to the blank line, but not the statement below.
>
>They're all seperate commands. Confusing (IMO), but syntactically valid.

Nancy,

I understand what's being said, and have given another attempt. Does this look better? (I haven't tested it yet):

SELECT data1.bundle as Total12;
FROM lumber!data1 into cursor bundata;
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 = bundata.Total12 + bundata.Total22 + bundata.Total32 + bundata.Total42 + bundata.Total52 + bundata.Total62 + bundata.Total72 + bundata.Total82