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!

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

Display Multiple Tables when Design report

Status
Not open for further replies.
pelagic

pelagic

Programmer
Nov 7, 2002
97
US
Hi All,
When design a report I click on the "Field List" button, this display only one table which is currently linking to the report. Is there a way to display multiple tables when design the report.

Thanks for the help,
regards
 
Sort by date Sort by votes
Hi pelagic

You need to create a query containing all the tables and fields you require for your report, and then base your report on that query.

Regards

Mac
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Print multiple copies of report data 1
Replies
5
Views
527
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
535
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
550
dhookom
dhookom
SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
635
dhookom
dhookom
monkeysee
  • Locked
  • Question
Muti Page Report 1
Replies
5
Views
499
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top