Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
no, not quite. In a nutshell, I have a form with 8 rows of comboboxes 5 comboboxes. combo 1 for each row is # of bundles, combo 2 is size of board (example: 2x4), combo 3 is length, and so on. Each row of combos has it's corresponding table; therefore 8 tables. The tables are linked by a P.O. number. IOW record 571 in table 1 goes with the same order as record 571 in table 2, and so on.
I need a report that generates as many rows as there are records, each row showing its corresponding po#, how many 2ft. bundles in the order, how many 4ft. bundles in the order, how many 6ft. bundles.......up to 20ft. bundles.
The database is in this form out of necessity due to calculations in other parts of the program.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement