multiple-column reports

B

Brian McNamara

Is there any way to print records from three different
tables in three different columns in an Access Report?
 
K

Kevin3NF

Create a query containing the 3 tables and the columns you want, then use
that query as the recordsource for the report.
 
P

PC Datasheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate One Pages from spreadsheet 0
Sorting Multiple Tables 1
Footer text appears "squished" 1
Setting column width in a table with a macro is not working 0
Treating multiple paragraphs as one 2
Weekly Report 2
Consolidation Table from Different Excel Tabs with Different Format 1
Sub projects added as read only in Master file which are saved on sharepoint 1

Top