Debug.Print "select * from Table1 Where time like " + "'" + Text1.Text + "-" + Text2.Text + "%" + "' and channel=" + "'" + CStr(i) + "'"你这样看就能看懂了。 双引内的完全输出，单引号是字符串引用。
