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!

Group labels

Status
Not open for further replies.

MAPetry

Technical User
Aug 2, 2000
43
US
O.K. probably stupid question but I can't figure out. I have a report that utilizes data from 3 tables. tblDivision (division code, division description), tblCompanies (company name, address, etc.), and tblCompanyDivisions (division and company name both linked back to respective tables). I want to print a report sorted by Division (No problem) However I can not get the division description contained in tblDivision to appear beside the Division Code that comes from tblCompaniesDivision. Any ideas.
 
Do you have relationships(joins) set up in your query for your report? If you do, you should be able to just add the devision description to the division header section of the report.
Mike Rohde
rohdem@marshallengines.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top