multiple-column reports

  • Thread starter Thread starter Brian McNamara
  • Start date Start date
B

Brian McNamara

Is there any way to print records from three different
tables in three different columns in an Access Report?
 
Create a query containing the 3 tables and the columns you want, then use
that query as the recordsource for the report.
 
Kevin's method is the way to do it if the three tables are related. If the
tables are not related, create three subreports, one based on each table, and
add the three subreports to an unbound main report so the three subreports are
side-by-side. Run the main report and you will get a report with three columns
where the data from the three tables is in separate columns.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel
 
Back
Top