MS Access数据表视图，如数据透视表 [英] MS Access datasheet view like pivot table

问题描述

大家好，


是否有可能在数据表中引入数据透视表视图。我们可以将数据分组并分别查看每个组的总数吗？

Hi Guys,

Is there any possiblity to bring pivot table view in datasheet. where we can group data and see the total on each group seperately ?

推荐答案

I知道可以使用查询或表来使用数据透视表，但我没有在Access中使用它们（只是玩了一下）。


打开时Dat中的表或查询在表格视图中，转到主页选项卡，视图组并选择数据透视表。我知道你可以从那里玩它，但不知道会有什么结果。

I know it is possible to work with Pivot Tables using a Query or Table, but I have not worked with them in Access much (just played around with them a bit).

When you open a Table or Query in Datasheet view, go to the Home Tab, Views Group and select Pivot Table. I know you can play with it from there, but not sure what results to expect.

感谢twinnyfo，但我想通过VBA制作数据透视表。我的意思是通过动态查询中的vba进行树视图结构数据表，从表单中更改用户选择。


请参阅以下网站，它将帮助您了解我正在寻找的内容。 />
http：//www.experts- exchange.com/Data..._27964604.html

Thanks twinnyfo, But I would like to make the pivot table through VBA. I mean a treeview structure datasheet through vba from a dynamic query which changes on user selection from a form.

Please see below site which will help you understand what I am looking for.

http://www.experts-exchange.com/Data..._27964604.html

Johny，


请记住，世界各有不同在树视图和数据透视表之间。是的，有一些相似之处，但它们有很大的不同。


如果你只是想要分组和总计，我认为你可以用报告做你想做的事情。和总和。表格不能那样工作。


如何使用Tree / Pivot？

Johny,

Keep in mind that there is a world of difference between a Tree View and a Pivot Table. Yes, there are some similarities, but they are much different.

If you just want grouping and totals, I think you can do exactly what you want to do with a report, with Grouping and Sums. Forms don''t work quite that way.

How is this Tree/Pivot going to be used?

这篇关于MS Access数据表视图，如数据透视表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！