各位，帮我看看以下代码如何修改！？

[wonsin]

做了一个时间比较的查询，即用现在的时间与表里的一个时间字段比较，代码如下：

If ComDay.Text = "一个月前使用过的" Then \\Comday为窗体上的一个文本框
Term = "{fn NOW()}- indate <= 30"
ElseIf ComDay.Text = "三个月前使用过的" Then
Term = "{fn NOW()}-indate>=30 and {fn NOW()}-indate<=90"
ElseIf ComDay.Text = "六个月前使用过的" Then
Term = "{fn NOW() }-indate>=90 and {fn NOW()}-indate<=180"
ElseIf ComDay.Text = "一年前使用过的" Then
Term = "{fn NOW()}-indate>=180"
End If
Txtstr= "select * from phoneinfo where Term "
Set Mrc = New ADODB.Recordset
Mrc.Open Txtsql, Conn, adOpenKeyset, adLockOptimistic
错误的提示为，term不对？！（注：{fn NOW()}-indate<=30 的语句在SQL查询分析器能通过）

[wonsin]

帮帮我呀！

[guolibin]

Txtstr= "select * from phoneinfo where " & Term

[longki]

在Tern中不是要在数字上加"'"号,比如: >='30'

[tmkwind]

Txtstr= "select * from phoneinfo where " & Term

[zuoxingyu]

应该是Txtstr= "select * from phoneinfo where " & Term

TERM在这里已经是个变量了，在SQL语句种不能直接识别。

[iiboy]

对呀,应该使用Txtstr= "select * from phoneinfo where " & Term