General information
Category:
Reports & Report designer
Hi Cetin,
Thanks for responding.
If this helps any . . . I have 2 combo boxes with conditional choices in each, and the following code is in the click event of a command button on the form.
public gdValue
gdValue = Thisform.gd1.displayvalue
public szValue
szValue = Thisform.sz1.displayvalue
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen12;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen22;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen32;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen42;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen52;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen62;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen72;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 2 ;
into array bunlen82;
acBundle2 = bunlen12+bunlen22+bunlen32+bunlen42+bunlen52+bunlen62+bunlen72+bunlen82
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen14;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen24;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen34;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen44;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen54;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen64;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen74;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 4 ;
into array bunlen84;
acBundle4 = bunlen14+bunlen24+bunlen34+bunlen44+bunlen54+bunlen64+bunlen74+bunlen84
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen16;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen26;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen36;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen46;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen56;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen66;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen76;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 6 ;
into array bunlen86;
acBundle6 = bunlen16+bunlen26+bunlen36+bunlen46+bunlen56+bunlen66+bunlen76+bunlen86
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen17;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen27;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen37;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen47;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen57;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen67;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen77;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 7 ;
into array bunlen87;
acBundle7 = bunlen17+bunlen27+bunlen37+bunlen47+bunlen57+bunlen67+bunlen77+bunlen87
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen18;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen28;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen38;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen48;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen58;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen68;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen78;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 8 ;
into array bunlen88;
acBundle8 = bunlen18+bunlen28+bunlen38+bunlen48+bunlen58+bunlen68+bunlen78+bunlen88
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen110;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen210;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen310;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen410;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen510;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen610;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen710;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 10 ;
into array bunlen810;
acBundle10 = bunlen110+bunlen210+bunlen310+bunlen410+bunlen510+bunlen610+bunlen710+bunlen810
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen112;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen212;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen312;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen412;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen512;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen612;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen712;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 12 ;
into array bunlen812;
acBundle12 = bunlen112+bunlen212+bunlen312+bunlen412+bunlen512+bunlen612+bunlen712+bunlen812
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen114;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen214;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen314;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen414;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen514;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen614;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen714;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 14 ;
into array bunlen814;
acBundle14 = bunlen114+bunlen214+bunlen314+bunlen414+bunlen514+bunlen614+bunlen714+bunlen814
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen116;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen216;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen316;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen416;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen516;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen616;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen716;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 16 ;
into array bunlen816;
acBundle16 = bunlen116+bunlen216+bunlen316+bunlen416+bunlen516+bunlen616+bunlen716+bunlen816
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen118;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen218;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen318;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen418;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen518;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen618;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen718;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 18 ;
into array bunlen818;
acBundle18 = bunlen118+bunlen218+bunlen318+bunlen418+bunlen518+bunlen618+bunlen718+bunlen818
SELECT data1.bundle ;
FROM lumber!data1 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen120;
SELECT data2.bundles ;
FROM lumber!data2 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen220;
SELECT data3.bundle ;
FROM lumber!data3 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen320;
SELECT data4.bundles ;
FROM lumber!data4 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen420;
SELECT data5.bundle ;
FROM lumber!data5 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen520;
SELECT data6.bundle ;
FROM lumber!data6 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen620;
SELECT data7.bundle ;
FROM lumber!data7 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen720;
SELECT data8.bundle ;
FROM lumber!data8 ;
WHERE grade = gdValue and siz = szValue and length = 20 ;
into array bunlen820;
acBundle20 = bunlen120+bunlen220+bunlen320+bunlen420+bunlen520+bunlen620+bunlen720+bunlen820
REPORT FORM siz_grade.FRX preview
*THIS REPORT HAS FIELDS ACBUNDLE2, ACBUNDLE4, ACBUNDLE6, ACBUNDLE7.......
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only