By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,475 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Help! Creating Reports Using Multiple Tables

P: n/a
Could someone explain clearly how to go about doing this? I have
tried setting up the structure on numerous occasions, but it never
seems to work. Could someone please help me out? Thanks!
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
If your report simply reports data from multiple tables, you first create a
query that joins the tables and then include the fields you need in the report.
Set the recordsource for the report to this query. If your report reports on
data that is in a one-to-many relationship such as Customers/Orders or
Invoice/Line Items you need to use a report and a subreport. Your main report is
based on the table on the one side or a query based on that table. Your
subreport is similarly based on the table on the many side or a query based on
that table. You create both reports separately. You then click and drag the
subreport to the details section of the main report and finally set the Link
Master and LinkChild properties of the subreport control to the primary
key/foreign key of the relationship.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<Sami> wrote in message news:r3********************************@4ax.com...
Could someone explain clearly how to go about doing this? I have
tried setting up the structure on numerous occasions, but it never
seems to work. Could someone please help me out? Thanks!

Nov 13 '05 #2

P: n/a
You'll probably want to create a query first. The query should include
fields from the set of tables you want to include in your report. Then
use the query as the record source for your report.

Post back if you need more help.

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

Sami <> wrote in message news:<r3********************************@4ax.com>. ..
Could someone explain clearly how to go about doing this? I have
tried setting up the structure on numerous occasions, but it never
seems to work. Could someone please help me out? Thanks!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.