用计算域计算 [英] Calculate with calculated field

问题描述

如何使用计算所得的字段进行计算?

例如
在项目表中有列
1.项目名称
2.物品率
3.项目数量
4.付款金额
我想要查询是否需要显示以下数据
1.商品名称
2.项目率
3.商品数量
4.总金额(按项目费率*项目数量)
5.付款金额
6.到期(付款总额)

我可以轻松创建总额"字段，但无法创建到期"字段
请帮助我解决

How can I calculate with a calculated field ?

For example
In Item table there are column
1.Item name
2.Item rate
3.Item quantity
4. Payment amount
I want a query were I need to show the following data
1.Item name
2. Item rate
3.Item quantity
4.Total amount (by item rate*item quantity)
5. Payment amount
6. due(Total amount-Payment amount)

I easily create Total amount field but I could not create due field
Please help me to solve

推荐答案

尝试一下

Try This

Select Itemname,Itemrate,Itemquantity,itemrate*itemquantity as Totalamount,Paymentamount,(itemrate*itemquantity)-Paymentamount as due
from ItemTable

这篇关于用计算域计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！