Getting Desired Field List (1 Viewer)

djruni

Registered User.
Local time
Today, 12:28
Joined
Jan 31, 2006
Messages
20
How do I get desired fields from various tables into the Field List when in the Design View of a report?

Lets say I have 5 tables and I want to get certain fields from each. I am guessing I need to make aquery to filter that info. After doing that, how do I import the query fields into the report's Field List...?
 

Smart

Registered User.
Local time
Today, 20:28
Joined
Jun 6, 2005
Messages
436
Create a query that selects all the fields you require from your 5 tables
Create a report and use type the query name in the reports record source

All the fields you selected in the query should now appear on the reports field list
 

Users who are viewing this thread

Top Bottom