本文介绍了尝试计算查询以提取报告的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

Hello All,我一直试图根据我昨天收到的回复来解决这个问题,但是我觉得我在这个过程中迷失了。我有一个表单,我有6个计算字段加上信息字段,如日期,类型等。但是,我现在倾向于使用查询这些字段来计算而不是在表单上计算。因此,我只是在表格中计算出以下字段;


表格字段1.名称GST = [每单位成本] * [数量] * 0.1

表格字段2.每件商品名称GST = [消费税] / [数量]

表格字段3.名称每件商品运费= [运费] / [商品及服务税总额]

表格字段4.名称总成本订单bf GST = [每单位成本] * [数量]

表格字段5.名称总GST包含= [总成本或商品及服务费用] + [消费税]

表格字段6.名称总运费+消费税= [运费] + [总消费税含税]


现在这些工作在表格上但不是查询。从我昨天收到的另一个查询答案建模

Hello All, I have been trying to work this out myself based on a response that I received yesterday which worked however I think I am lost in the process. I have a form which I have 6 calculated fields plus information fields like date, type etc. However, I now am gravitating to using the Query for these fields to calculate instead of calculating on the form. So simply the fields below are what I have calculated on the form;

Form Field 1. Name GST =[cost per unit]*[Qty]*0.1
Form Field 2. Name GST Per Item = [GST]/[Qty]
Form Field 3. Name Freight Cost per item =[freight cost]/[Total GST incl]
Form Field 4. Name Total cost order bf GST =[cost per unit]*[qty]
Form Field 5. Name Total GST incl = [total cost oder bf GST&freight]+[GST]
Form Field 6. Name Total Freight+GST =[freight cost] + [Total GST incl]

Now these work on the form but not on the query. modelled from an answer i received yesterday for another query

展开 | 选择 | Wrap | 行号

推荐答案


展开 | 选择 | Wrap | 行号


展开 | 选择 | Wrap | 行号


这篇关于尝试计算查询以提取报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-12 07:49