Desktop

Ask something
Discussion Locked

Creating columns in Access Report

0 helpful
3 replies

by brannuml 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have an Access report that has 3 columns
Name: Location: Transaction:

For each Name & Location sometimes there might be 20-30 transactions. Each transaction is a different record in a table. I would like to be able to wrap the Transaction field into multiple columns

Is this possible?? Please help!!!

Thank You
Laura

3 replies

by peyison

Hi Laura,

Are you wanting the Transactions to be listed across the report, like:

NAME LOCATION
TRANS1 TRANS2 TRANS3 TRANS4 ....

If this is true, would it be ok if it were like:

NAME LOCATION
TRANS1, TRANS2, TRANS3, TRANS4 ....

In other words, the transactions would be in one text box rather than each in its own. This would be easier since you don't have the same number of transactions each time.

Also - let me know if this is even what you're looking for.

This discussion is closed to new replies.