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

How do I link info I wanted from 2 or 3 SQL tables to my report

Status
Not open for further replies.

cps

Technical User
Feb 9, 2002
2
US
Can anybody help me?<br><br>I was trying to create a report & the info have to be extracted from 3 SQL tables. But it seems that I have problems linking becos in the Preview, i can only see the page headers i had input in the designing stage.<br><br>Appreciate your help. Thanks
 
What does your SQL statement look like? <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
How did you connect to your SQL Server? What are you using for your backend?<br><br>Basically, you need to use the link expert to connect your 3 tables together with the common field/keys. Once you do that, you'll be able to access fields from all three tables...until then, they will not be related to each other.<br><br>Tim<br><A HREF="mailto:trking@Mapconsulting.com">trking@Mapconsulting.com</A>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top