Loop calculation?
Hi :
As my previous stated that
-------------------------------------------------
total of G1: sum1
------------------------------------------------
total of G2: sum2
-------------------------------------------------
total of G3: sum3
-------------------------------------------------
sum 1 2 and 3 is db calc. In my database that sum field I used is called
'totalfinal'. according to sql linkage i have 3 duplicated totalfinal same
data for eachUser ID, I use dbsum fuction just want to add these field but
due to the date base duplicate date it add it 3 time, i just want it once.
Is that any way to type any code to help e this, can anyone help?
From JEs
As my previous stated that
-------------------------------------------------
total of G1: sum1
------------------------------------------------
total of G2: sum2
-------------------------------------------------
total of G3: sum3
-------------------------------------------------
sum 1 2 and 3 is db calc. In my database that sum field I used is called
'totalfinal'. according to sql linkage i have 3 duplicated totalfinal same
data for eachUser ID, I use dbsum fuction just want to add these field but
due to the date base duplicate date it add it 3 time, i just want it once.
Is that any way to type any code to help e this, can anyone help?
From JEs
This discussion has been closed.
Comments
Try using the dbCalc.SuppressRepeatedValues property to keep it from adding
more than once.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com