如何使用关键字之间触发ms访问查询 [英] how to fire ms access queries using between keyword

问题描述

SUM(CFD_PrincipalAmount)，其中AP_Indicator ="A"为先前AsOfDate与当前AsOfDate之间的天数.

我将在先前的AsOfDate和当前的AsOfDate之间的几天内，在该SUM(CFD_PrincipalAmount)上得到AP_Indicator ="A"的结果

给我适当的查询

SUM(CFD_PrincipalAmount) where AP_Indicator="A" for days between prior AsOfDate and current AsOfDate.

i wnt result on that SUM(CFD_PrincipalAmount) where AP_Indicator="A" for days between prior AsOfDate and current AsOfDate

give me proper queries

推荐答案

Select SUM(CFD_PrincipalAmount) where AP_Indicator="A" AND Column_date between Prior_date(''yyyy/mm/dd'')
AND Getdate(''yyyy/mm/dd'')

这篇关于如何使用关键字之间触发ms访问查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！