按组总计排序Access 2010报告 [英] Sort Access 2010 report by Group Total

问题描述

我有一份访问报告，提供供应商信息，如公司名称，订购商品，数量，价格等。

I have an access report that provides vendor information like company name, items ordered, quantities, prices, etc.

我按公司分组，以便显示所有内容我们在指定日期范围内从一个供应商订购，并提供我们与该供应商共同花费的总成本。

I have it grouped by company so that it shows everything we ordered from one supplier during a specified date range and provides the total cost we spent with that vendor.

他们希望按照每个供应商的总支出顺序查看此报告。因此，如果我们从供应商A购买总共100美元的4件商品和从供应商B购买的2件商品总共500美元，那么首先会在报告中列出供应商B，因为我们花了更多的钱用于他们的
。

They want to see this report in order by total spent with each supplier. So if we bought 4 items from vendor A for a total of $100 and 2 items from vendor B for a total of $500, vendor B would be listed on the report first because we spent more money with them.

这可能吗？如果是这样，我怎么能实现呢？

Is this possible? If so, how can I make it happen?

谢谢，

Jessica

推荐答案

报告对象本身没有这个功能（按子组总数排序）。

There is not a feature for this (sort by sub group total) within the report object itself.

你可以做的是创建一个独立的按供应商执行相同数学总计的查询。 创建该查询后 - 然后将其加入此报告的记录源查询。 该值是要排序的数据集的一部分。

What you can do is create a stand-alone query that does this same math total by vendor.  Once you've created that query - then you join it to the record source query for this report.  The value is then part of the data set to sort on.

这篇关于按组总计排序Access 2010报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！