ms-access - 选择过去一小时的数据，MS Access

Question

我正在做一些数据传输，将数据从一个数据库移动到另一个数据库，我希望在不使用运行此数据传输程序的计算机上太多内存的情况下执行此操作。目前该程序每分钟运行一次，但我想改变这一点，以便每小时获取数据。最终，我想更改以下查询，以便我不只是获取最大的值，而是获取过去一小时的数据:

SELECT Data.[Date / Time],
       DATA.[Hot Strip Mill Total],
       Data.[Basic Oxygen Furnace Total],
       Data.[Electro-Arc Furnace Total],
       Data.[J-9 Shop Total],
       Data.[Levy Maintence Building Total],
       Data.[Ford Body Shop Total],
       Data.[Ford Chiller Building Total],
       Data.[Ford Dearborn W Plant Total],
       Data.[Ford Dearborn E Plant Total], 
       Data.[Ford Dearborn Balcony Total], 
       Data.[Ford Final Assembly Total],
       Data.[Ford Frame Plant Total], 
       Data.[Ford Dearborn N Plant Total],
       Data.[Ford Tool and Die Total], 
       Data.[Ford Paint Plant Total],
       Data.[Ford Glass Plant Total], 
       DATA.[Hot Strip Mill Rate], 
       Data.[Basic Oxygen Furnace Rate], 
       Data.[Electro-Arc Furnace Rate],
       Data.[J-9 Shop Rate],
       Data.[Levy Maintence Building Rate],
       Data.[Ford Body Shop Rate],
       Data.[Ford Chiller Building Rate],
       Data.[Ford Dearborn W Plant Rate],
       Data.[Ford Dearborn E Plant Rate],
       Data.[Ford Dearborn Balcony Rate],
       Data.[Ford Final Assembly Rate],
       Data.[Ford Frame Plant Rate],
       Data.[Ford Dearborn N Plant Rate],
       Data.[Ford Tool and Die Rate],
       Data.[Ford Paint Plant Rate],
       Data.[Ford Glass Plant Rate]
       FROM DATA  
       WHERE Format(Data.[Date / Time], 'mm/dd/yyyy hh:nn:ss') >=
           (select Format(max(Data.[Date / Time]),'mm/dd/yyyy hh:nn:ss') from Data);

例如，现在是上午 10:51:00，我的程序现在正在运行，它将返回从大于 09:51:00AM 到现在的数据，同样在上午 11:51:00，返回从大于 10 开始的数据: 51:00 至上午 11:51:00。我对 Access 不太熟悉，但查询能力相当强。这让我迷失了。谁能帮助理解如何实现这一点？谢谢

Answer 1

由于 1 天 = 1，因此 1 小时 = 1/24。所以 - 只是为了好玩 - 你甚至可以将你的条件表达为

WHERE Data.[Date / Time] >= (Now()-1/24)