在记录集中怎么实现cha询时间段的金额求和？

369078170

如图，用的是Access，在易语言中怎么cha询某一个供应商9号到10一共有多少金额。

fasdfasfa

select sum(金额) from 日现金表 where 供应商='帮主' and 日期>=#2024-11-09 00:00# and 日期<=#2024-11-10 23:59#

鹏书

SELECT SUM(amount) AS total_amount
FROM orders
WHERE order_date BETWEEN '2024-01-01' AND '2024-02-01';

pshq123

SELECT SUM(amount) AS total_amount
FROM orders
WHERE name="帮主" order_date BETWEEN '2024-11-09' AND '2024-11-10';

369078170

fasdfasfa 发表于 2024-11-23 09:22
select sum(金额) from 日现金表 where 供应商='帮主' and 日期>=#2024-11-09 00:00# and 日期 ...

正在编译...
错误(10044): 不能将“整数型”数据转换到“文本型”数据。
内容
.版本 2
.支持库 spec
.支持库 eDB

调试输出 (数据库连接1.连接Access (取运行目录 () ＋ “\liushui.mdb”, “”))
调试输出 (数据库连接1.执行SQL (“select sum(金额) from 日现金表 where 供应商=” ＋ #单引号键 ＋ “帮主” ＋ #单引号键 ＋ “ and 日期>=#2024-11-09 00:00# and 日期<=#2024-11-10 23:59#”, ))

369078170

pshq123 发表于 2024-11-23 09:08
SELECT SUM(amount) AS total_amount
FROM orders
WHERE name="帮主" order_date BETWEEN '2024-11-09' AND ...

代码
.版本 2
.支持库 spec
.支持库 eDB

调试输出 (数据库连接1.连接Access (取运行目录 () ＋ “\liushui.mdb”, “”))
调试输出 (“SELECT SUM(amount) AS total_amount FROM orders WHERE name= ” ＋ #引号 ＋ “帮主” ＋ #引号 ＋ “order_date BETWEEN ” ＋ “'2024-11-09' AND '2024-11-10'”)
调试输出 (数据库连接1.执行SQL (“SELECT SUM(amount) AS total_amount FROM orders WHERE name= ” ＋ #引号 ＋ “帮主” ＋ #引号 ＋ “order_date BETWEEN ” ＋ “'2024-11-09' AND '2024-11-10'”, ))


输出
真
* “SELECT SUM(amount) AS total_amount FROM orders WHERE name= "帮主"order_date BETWEEN '2024-11-09' AND '2024-11-10'”
* 假

369078170

fasdfasfa 发表于 2024-11-23 09:22
select sum(金额) from 日现金表 where 供应商='帮主' and 日期>=#2024-11-09 00:00# and 日期 ...

错误问题搞好了，怎么没有返回，调试输出为真

369078170

鹏书 发表于 2024-11-22 23:30
SELECT SUM(amount) AS total_amount
FROM orders
WHERE order_date BETWEEN '2024-01-01' AND '2024-02-01 ...

调试输出为假