One to many - report design

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
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
 
Back
Top