各位先生：你们好！
请指教有关数据查询问题，本人在数据表中打算以一下方法进行复合查询，但语句错误总无法进行下去。Combo3、Combo4为壁厚值，即：要求查询某一材质（Combo2）与最大壁厚内某一范围数据（如：Combo3〈 最大壁厚〈Combo4）。请诸位先生帮忙解答并修改！谢谢。
北京
小虾
2006-8-21

sql = "select * from 浇注排序 where 材质 = '" & Trim(Combo2.Text) & "' and 最大壁厚 between #" & _
Trim(Combo3.Text) & "# and #" & Trim(Combo4.Text) & "# order by 材质 desc"

sql = "select * from 浇注排序 where 材质 = '" & Trim(Combo2.Text) & "' and 最大壁厚 between #" _
& " Trim(Combo3.Text) & "# and #" & Trim(Combo4.Text) & "# order by 材质 desc"

or

sql = "select * from 浇注排序 where 材质 = '" & Trim(Combo2.Text) & "' and " _
& " 最大壁厚 >= '" & Trim(Combo3.Text) & " ' and 最大壁厚 <= '" & Trim(Combo4.Text) & " ' " _
& " order by 材质 desc"

将sql = "select * from 浇注排序 where 材质 = '" & Trim(Combo2.Text) & "' and 最大壁厚 between #" & _
Trim(Combo3.Text) & "# and #" & Trim(Combo4.Text) & "# order by 材质 desc"
改为：
sql = "select * from 浇注排序 where 材质 = '" & Trim(Combo2.Text) & "' and 最大壁厚 between #" & _
Trim(Combo3.Text) & "# and #" & Trim(Combo4.Text) & "# order by n desc"
n是材质的列数。