Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

two tables on one page of report

Status
Not open for further replies.

MathTutor

Programmer
May 19, 2003
7
US
I want to print this:

Name: John Doe
Address:1234 5th St
L.A. CA 91402
Account#: 11223344

Table:Attendence
Date Type
1/2/04 A
1/9/04 M
1/16/04 A
2/5/04 A
2/19/04 P
etc....

Table:payments
Date OldBal Trans Amount NewBal
1/1/04 100 Fee 100 200
1/7/04 200 Pay -200 0
2/1/04 0 Fee 100 100
etc....


All payments are do by first of week. Any questions, please contact 1-800-905-xxxx


The main point is to print both tables on one page. Both tables are small and would fit on a single page.

 
Do you have a field that represents a link between the person table and the other two tables? If so, then look into creating a single report based on the fields in your person table, and insert 2 subreports, one for Attendance and one for Payments, both linked to the main report by the common field (probably the PK in the person table).



-Gary
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top