创建计算 [英] Creating calculations
问题描述
您好，
请帮助我解决问题，因为我正在努力使用Microsoft Acess来操纵数据并创建一个系统，该系统会为我的项目创建一个商店订单。我真的很感激任何帮助。
i有桌子
产品包括Prod_ID，Prod_Name然后价格
客户订单详情，包括订单，Order_ID，Prod_ID，Qty_on_Order，折扣，然后是Line_Total
i然后想知道插入最终总成本需要什么计算，因为表客户订单已经
Order_Total（将订单详细信息中所有Line_Total的总和加起来）
然后再加上交货成本，并按时间整数，然后生成最终成本
如果任何人能帮助我的话，
i真的很感激。我还想知道在哪里进行这些计算。创建新查询或使用现有表
Hello,
Please may someone help with a problem as i am struggling on using Microsoft Acess to manipulate data and crete a system which creates orders for a shop as part of my project. i really would be grateful for any help what so ever.
i have the tables
Products which include Prod_ID , Prod_Name and then Price
Customer Order Details which include in order, Order_ID, Prod_ID, Qty_on_Order, Discount and then Line_Total
i would like to know how to apply calculations so that I can times the price of a product by the quantity and discount and then get the line total
i then want to know what calcualtions are needed to insert a final overall cost as the table Customer Order has
Order_Total( which adds up the sum of all Line_Total in Order details)
and then adds Delivery Cost, and times byOverall_Discount and then to produce Final Costs
i would really be appreciative if any one could help me. i would also like to know where to place these calculations. do i create a new query or use the existing tables
推荐答案
通常我们在查询中使用算法。
所以放置两个查询中的Product表和Orderline，并通过ProductID加入它们。
接下来在图形编辑器中添加一个字段，如：
TotalPrice：[Qty] * [Price]
总计在groupby查询中重复使用此查询以获取每个OrderID和/或ProductID的总数。
获取想法？
Nic; o）
Normally we use an algoritm iin a query for this.
So place both the Product table and Orderline in a query and join them by the ProductID.
Next add a field in the graphical editor like:
TotalPrice: [Qty] * [Price]
For the overall total re-use this query in a groupby query to get the totals per OrderID and/or ProductID.
Getting the idea ?
Nic;o)
通常情况下，我们在查询中使用algoritm这个。
所以将Product表和Orderline放在查询中并通过ProductID连接它们。
接下来在图形编辑器中添加一个字段，如：
TotalPrice：[数量] * [价格]
总计在groupby查询中重复使用此查询以获取每个OrderID和/或ProductID的总数。 br />
Ge这个想法是什么？
Nic; o）
Normally we use an algoritm iin a query for this.
So place both the Product table and Orderline in a query and join them by the ProductID.
Next add a field in the graphical editor like:
TotalPrice: [Qty] * [Price]
For the overall total re-use this query in a groupby query to get the totals per OrderID and/or ProductID.
Getting the idea ?
Nic;o)
我很感谢你的回复。虽然不幸的是你不知道你的鬃毛是什么，因为我不知道你的意思是什么algoritm。在一个查询中，以及一个图形编辑器是什么。
i然后做了一个查询，但没有知道如何插入计算
对不起造成的任何麻烦，我对于任何帮助都非常有用。
i am grateful for your reply. Though unfortunatley do not under stand what you mane,as i do not know what you mean by "algoritm" in a query, and a what a graphical editor is.
i did however make a query but did not knkw how to insert the calculation
Sorry for any trouble caused, and i wouild really be grteful for any assisstance.
算法与计算相同：
a = b + c
你开始构建一个新的查询Access将显示一个窗口，在所选表格的上半部分（从首先显示的弹出窗口）和下面的一系列单元格。
第一行将保存字段名称，在第一行中您可以输入计算/算法，如：
总计：[数量] * [价格]
两者[数量]和[价格]需要在上半部分的表格中的字段。
试试看，让我知道结果。
Nic; o）
An algoritm is the same as a calculation like:
a = b + c
When you start to build a new query Access will show a window with in the upper half the selected table (from the pop-up form that''s displayed first) and below that a serie of cells.
The first row will hold the fieldnames and in that first row you can enter a calculation/algoritm like:
Total:[Qty]*[Price]
Both [Qty] and [Price] need to be fields in the table in the upper half.
Just give it a try and let me know the result.
Nic;o)
这篇关于创建计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
