A Report Total
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