Report from Multiple Tables

HalcyonDaze

New member
Local time
Yesterday, 23:08
Joined
Aug 12, 2010
Messages
8
This may be more of a Table issue than a Report Issue, but the Report is the final goal. I need to create a report that pulls from 3 separate tables.

Table A has a large (several hundred) list of instruments being used in a project. Table B has a list of spec sheet categories that are different for each type of instrument (60 max). Table C has the actual values for each instrument that would populate those categories.

The report needs to have a single page for each instrument, with the correct categories (Table B) populated into one column on the report, and the actual values for each instrument (Table C) populated into the other, It will also have to display Tag/Description/Location info from Table A.

I have no idea how to properly set up the database to allow this (something with table relationships I think?). Any thoughts?

PS its Access 2007 running on WinXP sp3
 
Is your task to create the report or the database first and then the report??

The Report will run off a Query that collects data from the three tables.
Reports, like forms, can only use One Record Source ie 1 table, 1 query etc.
No problems, just create 1 query to be that record source.

You can pull in additional data by way of Unbound Controls using DLookup or other method but this is not best for the bulk of your data.

A Report easily handles Calculated Controls eg Invoice Total is often just calculated by the Report.

The report can easily handle a new page for each Instrument and handle the sort Order.
 
Table A of the report exists; Im building Tables B and C, and the report to display it all.

So Ive built the Query, but its not returning right. Im pretty sure its something in the Relationship/Join setup. Tables A and C should have a 1-1 relationship; each instrument will have its own data sheet with settings. Table B on the other hand only has 5 records so far, one for each type of instrument. The Problem is that it is returning only 5 records. So how do I get it to return the hundreds of instruments, and copy in the categories to them all based on instrument type?

EDIT: Success! Took some dancing around to get the joins right, but its all good now.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom