combine sql query result

combine sql query result [无满意答案结帖,结帖人:monchichi1]

monchichi1
IT
等级:
可用分等级：长工
总技术分：0
总技术分排名：320310
结帖率：88.89%

发表于：2008-08-19 15:16:11 楼主

hi,is possible to combine sql query result??

for example:
machineno = A10
trecord = 12

combine result=A10&12

this is current code:

Dim rs1 As ADODB.Recordset
Dim rs2 As ADODB.Recordset
Dim rs3 As ADODB.Recordset
Dim partno As String
Dim machineno As String
Dim dimension As String
Dim startdate As String
Dim enddata As String

machineno = txtmachineno.Text
partno = combopartno.Text
dimension = Combodimension.Text
startdate = DTPicker1.Value
enddate = DTPicker2.Value

Set m_rs = OpenRecordset("SELECT * FROM spcdata", adOpenStatic, adLockOptimistic)
With combomachineno
.clear
Set rs2 = OpenRecordset("select Machineno,count(sampleno)as Trecords From spcdata where partno = '" & partno & "' and dimension ='" & dimension & "'and date between '" & Format$(startdate, "yyyy-mm-dd") & "' and '" & Format$(enddate, "yyyy-mm-dd") & "' group by machineno,dimension", adOpenStatic, adLockReadOnly)

While Not rs2.EOF
combomachineno.AddItem rs2!machineno & ""
rs2.MoveNext
Wend
rs2.Close
Set rs2 = Nothing
End With

please help.thanks

问题点数：20 回复次数：1 修改删除举报引用回复