怎么时间会有两个的?一个就够了啊。数据库设计是怎样的?select * from tablename where startime>='2004-7-1' and endtime<='2004-7-7'总觉得不太合理,一个字段就是:select * from tablename where 时间字段>='2004-7-1' and 时间字段<='2004-7-7'
谢了,两个时间字段,与现在时间比较的 可是我在VB中写了,不行,你帮我看看好吧,错在那 sql = "Select * from ZD_XINGXIFASONG where " _ & "sendstarttime >= #" & nowtime & "# and " _ & "sendendtime <= #" & nowtime & "# and " _ & "sendok=False and del=False "
可是我在VB中写了,不行,你帮我看看好吧,错在那
sql = "Select * from ZD_XINGXIFASONG where " _
& "sendstarttime >= #" & nowtime & "# and " _
& "sendendtime <= #" & nowtime & "# and " _
& "sendok=False and del=False "
跟踪sql语句
然后在access中执行就知道错误了