且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Access中转置表/查询?

更新时间:2023-11-18 21:51:28

自己关注了这个链接,它似乎为您的问题提供了一个体面的解决方案。我不确定你想从我们这里得到什么。


我知道这个概念并不是最简单的,但是如果你不理解它我就看不出我们怎么做救命。如果有一个具体的问题,你就会被问到,但我们不能为你做你的工作。


我们甚至不知道我们对你的特殊问题,但我们当然不会。
Having followed the link myself, it seems to provide a decent solution for your problem. I''m not sure what you want from us.

I know the concept is not the most straightforward, but if you can''t understand it I fail to see how we can help. If there''s a specific point you get stuck on ask away, but we can''t do your work for you.

We wouldn''t even if we did know enough about your particular problem, but we don''t anyway, of course.


我刚刚找到了你回答的其他问题。如果Excel是您的选项,那么它更简单。 Excel为您完成所有工作。 Access中没有这样的工具,即使可以设计一些工具来为您完成工作。
I''ve just found your other posted question, which I''ve replied to. If Excel is an option for you then it is much simpler. Excel does it all for you. Such a facility is not available in Access, even if something can be designed to do the work for you.


@jenniferhelen


我同意NeoPa的意见,发布的链接确实是一个不错的解决方案。我正在修改代码以消除目标参数。新目标名称将是源名称加 _Transposed 。如果目标已存在,则将其删除。您只需提供源名称。如果您不希望手动提供源名称,甚至可以一步一步地消除。我还将在演示数据库中包含所有这些功能,以便您可以更好地了解所有内容。要有耐心 - 很快就会见到你。
@jenniferhelen
I agree with NeoPa in that the posted Link is indeed a decent solution. I am revising the code to eliminate the Target Argument. The New Target Name will be the Source Name plus _Transposed. If the Target already exists, it will be Deleted. You will only need to supply a Source Name. If you do not wish to manually supply a Source Name, that can even be eliminated but one step at a time. I will also include all this functionality in a Demo Database for you, so you can get a better picture of everything. Be patient - will see you soon.