查询在Access数据库中给出错误 [英] Query is Giving Error in Access Database

问题描述

我在访问数据库中使用一个简单的选择查询来获取两个日期之间的记录，但记录输出为空。

I am using a simple select query in my access database to fetch the record between two dates but the record output is null.

SELECT * FROM Stocksheet
WHERE  [Date1]>#22-07-13 3:22:58 PM# and [Date1]<=#24-07-13 3:22:58 PM#
ORDER BY Stocksheet.[Date1] DESC;

我已经检查了 查询但它给出相同的输出null。当我写查询时





I have already checked by Between query but it is giving same output null. when i write the query

SELECT * FROM Stocksheet
WHERE  [Date1]<=#23-07-13 3:22:58 PM#
ORDER BY Stocksheet.[Date1] DESC;

然后它给出了记录数。但我需要两个日期之间的过滤数据行。

Then it gives number of records. but i needs a filter data rows between two dates.

推荐答案

试试这个（使用 BETWEEN ... AND ... 声明）：

Try this (using BETWEEN ... AND ... statement):

SELECT * FROM Stocksheet
WHERE (Stocksheet.[Date1] BETWEEN #7/13/2023# And #7/13/2023#)
ORDER BY Stocksheet.[Date1] DESC;

我建议你删除时间部分。

I would suggest you to remove time part.

我已经解决了这个问题。时间格式不正确，这就是它没有给出结果的原因。

I have solve the problem. Time Format is not correct thats why it were not giving result.

SELECT * FROM Stocksheet
WHERE (Stocksheet.[Date1] BETWEEN #2013/07/22# And #2013/07/24#)
ORDER BY Stocksheet.[Date1] DESC;

这篇关于查询在Access数据库中给出错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！