General discussion

Locked

Creating columns in Access Report

By brannuml ·
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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Creating columns in Access Report

by Peyison In reply to Creating columns in Acces ...

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.

Collapse -

Creating columns in Access Report

by brannuml In reply to Creating columns in Acces ...

Poster rated this answer

Collapse -

Creating columns in Access Report

by brannuml In reply to Creating columns in Acces ...

This question was closed by the author

Back to Desktop Forum
3 total posts (Page 1 of 1)  

Related Discussions

Hardware Forums