>SELECT data1.bundle as Total12; >FROM lumber!data1 into cursor bundata; >WHERE siz = szValue and grade = gdValue and length = 2;...snip
>tb2 = bundata.Total12 + bundata.Total22 + bundata.Total32 + bundata.Total42 + bundata.Total52 + bundata.Total62 + bundata.Total72 + bundata.Total82First, you can drop the semi-colons at the end of the command. Not needed and a potentional trap if you every accidentally add a line of code after w/o inserting a blank line.
SELECT INTO
a different cursor...you overwrite each one with the next select. You want to end up with one cursor per SELECT statement.