A Report Total

From: Greg Williams <greg.williams_at_lambdaconsulting.com>
Date: Fri, 2 Jul 1999 14:49:10 -0400
Message-ID: <7lj1f0$b5t$1_at_nntp8.atl.mindspring.net>



I have a table that finds the total of certain values for months in a year:
                       Oct              Nov              Dec        ....
... Total
Labor
Travel
Material
Shipping
Totals -------- --------- ---------- ... ... Grand Total

I have 10 of these instances, one for each of these:

WBS                       TASK
510                          0
511                          1
511                          2
511                          3
511                          4
513                          1
513                          2
513                          3
514                          0
645                          0

I have no trouble finding the totals for each of the TASK types (just a combination of WBS and TASK for the total). My problem is finding the total of all Grand Totals above for each WBS (not TASK) in a report using the TASK totals I already have (the Grand Totals) in a report. I know this sounds confusing, and I'm sorry for that, and that's why I'm asking.

I tried making a report query that is SELECT DISTINCT WBS FROM CE_WBS_MASTER. This did the job of listing out the WBSes. Then I created a query that would add up the Grand Totals for whichever WBS is currently in the frame. Needless to say, it didn't work.

Can anyone help me?

Greg Williams

begin 666 Greg W. Williams.vcf
M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..E=I;&QI86US.T=R96<[5RX- M"D9..D=R96<_at_5RX_at_5VEL;&EA;7,-"D]21SI,86UB9&$_at_0V]N<W5L=&EN9SM4 M96-H;FEC86P-"E1)5$Q%.D-O;&0_at_1G5S:6]N($%D;6EN+U=E8FUA<W1E<@T* M5$5,.U=/4DL[5D])0T4Z*#<U-RD_at_-#8W+3$U-C$-"E1%3#M(3TU%.U9/24-% M.B_at_W-3<I(#0V-RTQ-38Q#0I414P[0T5,3#M63TE#13HH-S4W*2 T,3_at_M,#8X M,_at_T*5$5,.U!!1T52.U9/24-%.FYO;F4-"E1%3#M73U)+.T9!6#IN;VYE#0I! M1%([5T]22SH[*#<U-RD_at_-#8W+3$U-C$[.U9I<F=I;FEA($)E86-H.U9!.SM5 M4T$-"DQ!0D5,.U=/4DL[14Y#3T1)3D<]455/5$5$+5!224Y404),13HH-S4W M*2 T-C<M,34V,3TP1#TP059I<F=I;FEA($)E86-H+"!603TP1#TP055300T* M0412.TA/344Z.SL[5FER9VEN:6$_at_0F5A8V@[5D$[,C,T-C0[55-!#0I,04)% M3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z5FER9VEN:6$_at_0F5A M8V_at_L(%9!(#(S-#8T/3!$/3!!55-!#0I8+5=!0BU'14Y$15(Z,_at_T*55),.@T* M55),.FAT=' Z+R]W=W<N;&%M8F1A8V]N<W5L=&EN9RYC;VT-"D5-04E,.U!2 M148[24Y415).150Z9W)E9RYW:6QL:6%M<T!L86UB9&%C;VYS=6QT:6YG+F-O D;0T*4D56.C$Y.3DP-S R5#$X-#DQ,%H-"D5.1#I60T%21 T* `
end Received on Fri Jul 02 1999 - 20:49:10 CEST

Original text of this message