How do I create a report with multiple sources?

[DMHCCI]

My challange is this. I have a table (A) that has Prop-Key,Name,& address. This table is related one to many to two other tables:

Table (B) has Prop-Key, Code, Desc, Exemption Amount
Table (C) has Prop-Key, Code, Desc, Rate, Levy Amount

I would like the header of the report to show the the table (A) information. I would Table (B) data to show up in rows. I would also like a separate section of the report to show table (C) data in rows.

Header - Property Information from Table (A)

Detail - Exemption Information Table (B)

Row 1
Row 2
Row 3
...

Detail- Levy Information Table (C)

Row 1
Row 2
Row 3
...

 

[GDGarth]

You can create a query to combine the data in all three tables, or use a subform to display related data from the other tables.

You should be able to use the wizard to create a query.

 

[DMHCCI]

Thankyou for your quick response. Table (B) and (C) when combined with (A) would be like combining apples and oranges. So I think the sub form would be the best Idea. My only thought question on using a subform is - how do you keep it from looking like you pasted a subform on your report as opposed to having it look like the rest of the report?

 

[CTOROCK]

remove the borders and display effects

"The greatest risk, is not taking one."