MS Access 使用 UNION Select 查询时无法按日期范围进行筛选-解网

问：

我有一个 MS Access 数据库，其中包含每个国家/地区的表格。

我创建了一个 UNION Select 查询来联接数据库中的所有表，以便我可以筛选出国家和日期并进行计算。

当我过滤一个日期时，结果是正确的。但是当我过滤日期范围时，我得到不正确的结果。日期格式似乎错误？

下面是 UNION Select 查询。我已经尝试过使用和不使用格式功能

SELECT "Argentina" as Country, Format([Argentina - Immediate Refund].[Date sent], "Short Date") As [Date sent], [Argentina - Immediate Refund].[Received date], [Argentina - Immediate Refund].[Released date], [Argentina - Immediate Refund].[Processed Forms] FROM [Argentina - Immediate Refund]

UNION ALL SELECT  "Austria" as Country, Format([Austria - Immediate Refund].[Date sent], "Short Date") As [Date sent], [Austria - Immediate Refund].[Received date], [Austria - Immediate Refund].[Released date], [Austria - Immediate Refund].[Processed Forms] FROM [Austria - Immediate Refund];

这是我筛选从 2023 年 1 月 10 日到 2023 年 1 月 11 日的日期时的结果截图

在此处输入图像描述

我尝试在SQL语句中更改日期格式

访问SQL MS-Access

SELECT 
    "Argentina" as Country, 
    [Date sent],
    [Received date], 
    [Released date], 
    [Processed Forms] 
FROM 
    [Argentina - Immediate Refund]

UNION ALL 

SELECT  
    "Austria" as Country, 
    [Date sent], 
    [Received date], 
    [Released date], 
    [Processed Forms] 
FROM 
    [Austria - Immediate Refund];

要将文本日期转换为真实日期值，请执行以下操作：

    "Argentina" as Country, 
    CVDate([Date sent]) As DateSent,
    CVDate([Received date]) As ReceivedDate, 
    CVDate([Released date]) As ReleasedDate, 
    [Processed Forms]

MS Access 使用 UNION Select 查询时无法按日期范围进行筛选

MS Access Cannot filter by date range when using UNION Select query

评论

评论