求SQL查询方法:
要从ACCESS数据库中查询三个字段"姓名""身高""体重",VB窗体上有四个文本框heightmin,heightmax,weightmin,weightmax,分别输入身高和体重的最大值和最小值,根据输入的身高范围和体重范围查询出满足条件的记录的姓名、身高和体重,请问这个查询语句怎么写,怎样把文本框中的值赋给查询语句(直接写身高between heightmin.text and heightmax.text是不行的)
要从ACCESS数据库中查询三个字段"姓名""身高""体重",VB窗体上有四个文本框heightmin,heightmax,weightmin,weightmax,分别输入身高和体重的最大值和最小值,根据输入的身高范围和体重范围查询出满足条件的记录的姓名、身高和体重,请问这个查询语句怎么写,怎样把文本框中的值赋给查询语句(直接写身高between heightmin.text and heightmax.text是不行的)
sql = "select * from xxx where 体重 between " & heightmin.text & " and " & heightmax.text
Dim strSQL As String
strSQL = "select 姓名,身高 from mytable where 身高 between " & heightmin.Text & "and" & heightmax.Text
将heightmin.Text 和heightmax.Text换成数字就可以
strSQL = "select 姓名,身高 from mytable where 身高 between " & val(heightmin.Text) & "and" & val(heightmax.Text)
Dim minHeitght as Single
Dim maxHeitght as Single
Dim minWeight as Single
Dim maxWeight as Single
Dim strSQL As String minHeitght = heightmin
maxHeitght = heightmax
minWeight = weightmin
maxWeight = weightmaxstrSQL="select * from 表 where height between " & minHeight & " and " & maxHeight & " and weight between " & minWeight & " and " & maxWeight & "
最后少了个双引号,更正一下
strSQL = "select 姓名,身高 from mytable where 身高 between " & val(heightmin.Text) & "and" & val(heightmax.Text)""
最后面少了两个引号,再试试
strSQL = "select 姓名,身高 from mytable where 身高 between " & val(heightmin.Text) & "and" & val(heightmax.Text) & ""
应该是这样的
终于解决了,哈哈,就是and前后没加空格的问题,谢谢大家这么热心了