Good morning To everyone, I have two select, I'm displaying next to each other, I need to add the value of a select with that of the other .. is it possible? the two select are separate tables, I'm displaying one value next to the other, but I need to add those values ... please if anyone knows I need help. follow the code of the select:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DBQ=" & Server.MapPath("banco.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}","username","password"
strQ = "SELECT * FROM Vendas2017 ORDER BY id asc"
Set ObjRs = objConn.Execute(strQ)
Set objConn2 = Server.CreateObject("ADODB.Connection")
objConn2.Open "DBQ=" & Server.MapPath("banco.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}","username","password"
strQ2 = "SELECT * FROM Vendas2018 ORDER BY id asc"
Set ObjRs2 = objConn2.Execute(strQ2)