访问报告 - 水平对齐结果 [英] Access Reports - Align Results Horizontally

问题描述

新用户，这似乎很容易创建，而且我在思考。简而言之，我有一个带有NAME字段的表，然后是他们可能玩的每个位置的字段。 PITCHER，CATCHER，SS等。


我想创建一个报告，其中每个字段都标记在顶部。然后，如果他们玩那个位置，它会将他们的名字插入位置colume。我运行了一个提取信息的查询，然后当我把它放在一个报告中时，每个colume的结果都没有从第一行开始，它留下了很大的空白。这就是我得到的。

展开 | 选择 | Wrap | 行号

解决方案

我是对不起，你的意思是这是结果吗？

PITCHER CATCHER SS

Smith King Jones

Jone Glass Cline

或者你真的希望重复名称如图所示吗？

Opps，我也想要你的SQL。

请记住使用< CODE />格式化它按钮。


通过向我们提供底层查询的SQL，我们可以使用相同的字段名称，并检查以确保没有根本错误。

@zmbd


我在问题上张贴的间距是关闭的，但第二个是想法。我正在寻找的结果（当然使用我表中的所有记录）。第一个表格是我得到的结果。


名称重复，因为它们可能同时扮演PITCHER和CATCHER两个位置，因此根据查询填写了该colume的姓氏我在Office 2007中设置了Access。再一次，查询正在运行，但是当我把它放在一个报告中时，正如你所看到的，这些columes并不是在细节部分中都是水平排列的。我希望每个colume都填充在第1行，而不是留下空白。

我只想让它有3个标记为PITCHER，CATCHER，SS的游戏，然后让玩家的名字列在他们玩的colume（或位置）下面。他们可以扮演两个或三个位置，因此每个colume下都会有名字。那有意义吗。


PITCHER CATCHER

new user and this seems like it would be easy to create, and i''m way over thinking. in short i have a table with a NAME field, and then a field for each position they may play. PITCHER, CATCHER, SS, ETC.

i want to create a report where each of my fields are labeled at top. Then if they play that position it will plug their name in the position colume. i ran a query which pulls the information, then when i put it in a report, the results for each colume do not start on line one of detail, it leaves big gaps. this is what i''m getting.

Expand|Select|Wrap|Line Numbers

解决方案

I''m sorry, do you mean this is the result?

PITCHER CATCHER SS
Smith King Jones
Jone Glass Cline

Or do you really want the names repeated as shown?

Opps, I also meant to ask for your SQL.
Please remember to format it using the <CODE/> button.

By giving us your SQL for the underlying query, we can use the same field names and also check to make sure that there isn''t something fundamentally wrong.

@zmbd
the spacing is off with what I posted on my question, but the second one is the "idea" of the result im looking for (of course using all the records in my table). The first table is the result I am getting.

the names are repeated because they may play both positions, PITCHER and CATCHER, therefor the last name was filled in that colume based on the query i set up in office 2007, Access. Again the query is working, however when i put it in a report, as you can see, the columes don''t all line up horizontally in the detail section. I want each colume to populate on line 1, not leave gaps.
I simply want it to have 3 columes labeled PITCHER, CATCHER, SS and then have the players name listed under the colume (or position) in which they play. they may play two or three positions, so there name would populate under each colume. does that make sense.

PITCHER CATCHER

这篇关于访问报告 - 水平对齐结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！