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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Making a Report From Two Tables

Status
Not open for further replies.

Fortborg

Technical User
Jul 26, 2001
15
0
0
US
I have a database setup with two tables.

Table A contains Name, Address, Phone number, ect..

Table B contains Item Descriptions, Costs, ect..

I need a report that will make a printout with:

Name
Address
Description 1
Description 2
Description 3
Amount Total:

How can I do this?

Any help much appreciated.
 
I don't see anything that links the two tables together, but if you do have a column that links them together, you can create a query to join the two tables and then create your report from your query. Another option may be to set up a subreport of the description data and insert the subreport into your report, although the specifics are unknown without knowing what exactly in the tables join them together. Hope this helps get you started.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top