尝试在查询中总结大量信息 [英] trying sum large amount of info in query

问题描述

好的我这个很难解释所以我会尽量给出尽可能详细的信息。


我需要做的是建立一个堆积柱形图访问一组信息，每个产品线有13条不同的产品线，大约有2100条信息记录。每个记录都是一个状态，例如（abc stock，def stock，to go，installed，abc shipping，def shipping，na）我需要做的是做一个库存。包括abc和def stock两者的运输，包括abc和def运输的运输，以及to go，installed和na两种类型的运输。类别，我需要总计每个产品系列的每个分类中的记录数。我需要它以一种可用的方式，所以我可以建立堆积柱形图。我希望这是足够的信息，而且有人可以帮助我，我花了很多时间在一些似乎应该如此简单的事情上。非常感谢任何帮助。



再次感谢。

Ok I this one will be tough to explain so i''ll try to give as much detail as possible.

What i need to do is build a stacked column chart in access off a set of information that has 13 different product lines for each product line there is about 2100 records of information. Each record is a status for example (abc stock, def stock, to go, installed, abc shipped, def shipped, na) what i need to do is make a "in stock" category that would include both abc, and def stock, a shipped that would include both abc and def shipped, and a "to go", "installed", and "na" category, I need to total the number of records in each categoy for each product line. and i need it in a useable manner so i can build the stacked column chart. I hope this is enough information and that someone can help me I have spent way to much time on something that seems like it should be so easy. any help is greatly appreciated.


Thanks again.

推荐答案

不确定我是否完全了解你如下所示：

Not sure if I understand you fully but something like the following:

展开 | 选择 | Wrap | 行号

感谢您的回复！我认为你的理解非常接近......我的表中每个产品系列都是不同的列，所以我需要总结13个不同的产品系列，有2100行，这些值是我需要求和或计算的状态我猜想更准确。再一次任何帮助都很棒。


谢谢，

Thanks for your reply! I think your pretty close in your understanding... each product line is a different column in my table so i need to sum 13 different product lines, there are 2100 rows and the values are the status that i need summed or counted I guess would be more accurate. And again any help is great.

Thanks,

你需要发布你桌子的元数据，因为我不知道我是否完全明白你在做什么。


这是一个如何发布表元数据的例子：

表名= tblBookings

You''ll need to post the metadata for your table as I don''t know if I fully understand what you are doing.

Here is an example of how to post table MetaData :
Table Name=tblBookings

展开 | 选择 | Wrap | 行号

这篇关于尝试在查询中总结大量信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！