By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,223 Members | 1,608 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,223 IT Pros & Developers. It's quick & easy.

Change Text Box Display in Reports

P: n/a
I have data a query produces which looks like:
(The two fields are division and item)

Division___Item
A_________X
A_________Y
A_________Z
B_________P
B_________Q
B_________R
My report arranges the data to look like:

Division A
X
Y
Z

Division B
P
Q
R
The way I'd like the report to look is:

Division A
X, Y, Z

Division B
P, Q, R

Is there a way this can be done?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"jujubean" <ha**********@yahoo.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
I have data a query produces which looks like:
(The two fields are division and item)

Division___Item
A_________X
A_________Y
A_________Z
B_________P
B_________Q
B_________R
My report arranges the data to look like:

Division A
X
Y
Z

Division B
P
Q
R
The way I'd like the report to look is:

Division A
X, Y, Z

Division B
P, Q, R

Is there a way this can be done?


Check out crosstab query.
Set Division to Row Heading
Set Item to Column Heading
Fred Zuckerman
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.