我的查询中有什么问题 [英] What Problem in my query

问题描述

 rs.Open  从purch中选择PDATE，plan，NAME，PQNTY pdate> =& DTPicker1.Value&  和pdate< =& DTPicker2.Value&  按名称排序，pdate，cn，adOpenKeyset，adLockOptimistic 

现在rs = 0，但是

 rs.Open   按名称选择PDATE，plan，NAME，PQNTY，pdate，cn，adOpenKeyset，adLockOptimistic 
 
 rs。 Filter =   pdate> =& DTPicker1.Value&  和pdate< =& DTPicker2.Value 

rs＃0为什么？请给出答案代码

解决方案

要从MS Acces数据库中获取正确的值，您需要在＃之间取日期

   SELECT PDATE，plan，[NAME]， PQNTY来自purch& vbcr& _ 
   WHERE pdate> =＃& DTPicker1.Value&  ＃和pdate< =＃& DTPicker2.Value&  ＃& vbcr& _ 
   ORDER BY [name]，pdate 

BTW：名称是MS Access中的保留字，所以......要使用它你需要把它放在括号中 []



要从MS SQL Server获取正确的值，您需要在'之间取日期

< pre lang =vb> SELECT PDATE，plan，[NAME]，PQNTY from purch& ; vbcr& _
WHERE pdate> ='& DTPicker1.Value& '和pdate< ='& DTPicker2.Value& '& vbcr& _
ORDER BY [name]，pdate

我建议你使用 BETWEEN ... AND ... [ ^ ]语句。

有关在MS Access数据库中过滤数据的更多信息：查询条件示例 [ ^ ]



我差点忘了...

在MS Access数据库中，查询日期必须格式化为 MM / dd / yyyy （美国格式）。

试试这个.. :)

  SELECT  *  FROM  TableName 
  WHERE （date_field  BETWEEN  '  2010-01-30 14:15:55'  AND  '  2010-09-29 10:15： 55'） ORDER   BY  colimn1  ASC ，column2  DESC  

rs.Open "select PDATE,plan,NAME,PQNTY  from purch where pdate>=" & DTPicker1.Value & " and pdate<=" & DTPicker2.Value & " order  by name,pdate", cn, adOpenKeyset, adLockOptimistic

now rs=0, but

rs.Open "select PDATE,plan,NAME,PQNTY from purch  order by name,pdate ", cn, adOpenKeyset, adLockOptimistic

rs.Filter = "pdate>=" & DTPicker1.Value & " and pdate<=" & DTPicker2.Value

rs # 0 Why ? Please give answers are code

解决方案

To get proper values from MS Acces database, you need take dates between #

"SELECT PDATE, plan, [NAME], PQNTY  from purch" & vbcr & _
"WHERE pdate>=#" & DTPicker1.Value & "# and pdate <= #" & DTPicker2.Value & "#"  & vbcr & _
"ORDER BY [name], pdate"

BTW: Name is reserved word in MS Access, so... to use it you need to take it in a brackets []

To get proper values from MS SQL Server, you need take dates between '

"SELECT PDATE, plan, [NAME], PQNTY  from purch" & vbcr & _
"WHERE pdate>='" & DTPicker1.Value & "' and pdate <= '" & DTPicker2.Value & "'"  & vbcr & _
"ORDER BY [name], pdate"

I would suggest you to use BETWEEN ... AND ...[^] statement.
More about filtering data in MS Access database: Examples of query criteria[^]

I almost forgot...
In MS Access database queries dates must be formated as MM/dd/yyyy (US format).

try this..:)

SELECT * FROM TableName 
WHERE  (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55') ORDER BY colimn1 ASC,column2 DESC

这篇关于我的查询中有什么问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！