Report Based on Multiple Tables

A

Access Idiot

Any help on this greatly appreciated.

I have built a database for a small carpentry company. I put all of the
customer information in one table. Project Information in another table.
Materials, Labour, and Incidentals each in a table. I have related them by
Project ID to the Projects table, and The customer and Projects table is
related by Customer Id.

I have all of my forms functioning as I wish, however it is now time to
build some reports, such as Invoices, customer information, and Project
Information.
Any report or Query that I try and build with fields from each of these
tables is not bringing up any records at all. My hope was that I could
simply choose wich Customer ID or Project ID I wanted and get the relative
information.

Thoughts please?

Thanks so much.
Todd
 
R

Rick B

You would have to base your report on a query that contains all the tables
you need to use.

Simply open the report's properties box, find the "data source" item. Click
the ellipse to the right of the item to open the builder. add whichever
tables you need (make sure they link properly).

Then include whatever fields you want down in the query.
 
A

Access Idiot

Doesnt Bring up an records. I always end up with an empty query, and I am
quite sure my relaionships are alright.
 
A

Access Idiot

I managed to get some records to come up, however it isnt the proper
information. It is only 2 records that consistently repeat themselves.

Sql is below.
SELECT Projects.ProjectID, Projects.CustomerID, Projects.Name,
Projects.[Start Date], Projects.[End Date], Customers.[Customer Name],
Customers.[Business Name], Customers.[Phone Number], Customers.[Street
Address], Customers.City, Customers.Province, Customers.[Postal Code],
Incidentals.Description, Incidentals.Quantity, Incidentals.Price,
Incidentals.Total, Labour.Date, Labour.Hours, Labour.Total,
Materials.Quantity, Materials.Description, Materials.Price, Materials.Total
FROM (((Customers INNER JOIN Projects ON Customers.CustomerID =
Projects.CustomerID) INNER JOIN Incidentals ON Projects.ProjectID =
Incidentals.ProjectID) INNER JOIN Labour ON Projects.ProjectID =
Labour.ProjectID) INNER JOIN Materials ON Projects.ProjectID =
Materials.ProjectID;
 
Top