Trying to get the sum from two different clolums a
I am trying to get the sum from two columns in seperate tabels, here's my code sample can someon help?
[code]
strSQL = select sum(total1 + total2) as GrandTotal from
sum1 inner join sum2 on key1 = key2
Select sum(DEU_Certification + Qtrly_Rpt_Regs)as Grandtotal from sum1 inner join sum2 on key 1 = key2
Dim intAddition
intAddition = request.form("1_Name_and_Location_of_Examining_Off ice") + request.form("1_Name_and_Location_of_Examining_Off ice") + request.form("2_Number_of_Applicants_Processed") + request.form("2_Number_of_Applicants_Processed") + request.form ("3_Number_of_Slections_Made") + request.form("3_Number_of_Slections_Made")
+ request.form("4_Number_of_Preference_Eligibles_Sel ected") + request.form ("4_Number_of_Preference_Eligibles_Selected")+ request.form("5_Number_of_Certificates_Issued") + request.form("5_Number_of_Certificates_Issued") + request.form("6_Number_of_Certificates_Not_Used") + request.form("6_Number_of_Certificates_Not_Used") + request.form("7_Number_of_certificates_unused_beca use_of_CTAP_IC TAP")
+ request.form("7_Number_of_certificates_unused_beca use_of_CTAP_IC TAP")
conn.Execute strSQL
conn.Close
Response.Redirect("Comments.asp")
End If
%>
|
