访问报告 - 带有文本值的交叉表 [英] Access Report - crosstab with text values

问题描述

目前有一个包含姓名，列字母和部门的表格。我试图让名字与报告在同一行上打印。它目前看起来像（期间只是消息中的间距）





DEPARMENT＃1



A ....... B ....... C ....... D

史密斯

。 ........琼斯

......... Gyrn

............... .......加斯顿

.............................麦克劳德

............................. Tupou

........ .....................特蕾西



部门＃2（等）



我想要的是

DEPARMENT＃1



A ........ .... B ............ C ................ D

史密斯...琼斯.. ..Gaston .. McCloud

.............. Gyrn ..................... .... Tupou

..................................... ............ Tracy



这可能吗？注释 - 将始终只有四列，但每个部门/字母组合最多可以有12个名称。

Currently have a table with names and column letter and department. I am trying to get the names to print on the same row with the report. It currently looks like (periods are just for spacing in the message)


DEPARMENT#1

A.......B.......C.......D
Smith
.........Jones
.........Gyrn
......................Gaston
.............................McCloud
.............................Tupou
.............................Tracy

DEPARTMENT #2 (etc)

What I want is
DEPARMENT#1

A............B............C................D
Smith...Jones....Gaston .. McCloud
..............Gyrn.........................Tupou
.................................................Tracy

Is this possible? Notes - will always only be four columns, but can be up to 12 names per department/letter combination.

推荐答案

这篇关于访问报告 - 带有文本值的交叉表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！