One to many - report design

I have 2 tables, Master (one) and Transactions (many). The tables link with
custid. I would like to print each transaction in the Transactions table for
each person in the Master table horizonally. I need to put conditions on it
so they print in the correct column.

Example:

Person, address

Transaction Transaction Transaction
Transaction

Person, address

Transaction
Transaction


The amount of transactions could be different for each person but they will
need to print the same types of transaction in each column.

Any ideas would be appreciated. Do I need to write code to create a query
that carries one record per person?

Thanks, Sarah

Sarah

?!"Type of transaction"?!

?!...in the correct column"?!

We aren't there, so it's kind of tough figuring out how you've defined
these.

(?are you talking about using a crosstab query?)

Regards

Jeff Boyce
Access MVP

"Sarah" wrote in message
...
I have 2 tables, Master (one) and Transactions (many). The tables link
with
custid. I would like to print each transaction in the Transactions table
for
each person in the Master table horizonally. I need to put conditions on
it
so they print in the correct column.

Example:

Person, address

Transaction Transaction Transaction
Transaction

Person, address

Transaction
Transaction


The amount of transactions could be different for each person but they
will
need to print the same types of transaction in each column.

Any ideas would be appreciated. Do I need to write code to create a query
that carries one record per person?

Thanks, Sarah

Sarah,
Try to use a sub report that lists only transactions and put them in columns,
for this you will need to make a report for just transactions and insert it
into the report as a sub report, then link the child and master fields in
properties box for the report and sub report.

Hope this helps
KB

Sarah wrote:
I have 2 tables, Master (one) and Transactions (many). The tables link with
custid. I would like to print each transaction in the Transactions table for
each person in the Master table horizonally. I need to put conditions on it
so they print in the correct column.

Example:

Person, address

Transaction Transaction Transaction
Transaction

Person, address

Transaction
Transaction

The amount of transactions could be different for each person but they will
need to print the same types of transaction in each column.

Any ideas would be appreciated. Do I need to write code to create a query
that carries one record per person?

Thanks, Sarah


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200508/1