Table of calculated fields

[Chky071]

Have a couple of databases that house all the information that I need. I am looking to create a table or query where I can house a bunch of calculated fields.



For example:
My master database contains the following fields
Part Number
Heater #1
Heater #2

I have another database that contains information about the heaters
Heater Part number (Corresponds to Heater #1 and/or Heater #2)
Length

I want to create a table or query where for each part number it shows me the total length of all heaters. I am running into trouble because sometimes a part will not have a second heater.

I created a query and I created a relationship between heater#1 and heater Part number, the query works fine. When I create a relationship between Heater #2 and heater part number (I link it to a second instance of the same heater database, because otherwise it can't tell which "Length" I am talking about) I can only then see the main part numbers that have a heater in the "Heater #2" field. I have tried "is null" and they still do not show up.

What is the best way to handle something like this? I am assuming a query is the way to go, but I just can't seem to get it to show me everything whether null or not

Thanks

[June7]

Are you using INNER JOINs?

[Chky071]

What are INNER JOINs? I am new to Access.

[June7]

In the query designer, double click on the line that links tables to open Join Properties dialog. You will see 3 options for join type. Need the one that says something like: Include ALL records from 'master table' and only those from 'heaters' ...

Switch query builder to SQL View to see the actual SQL statement.

[Chky071]

Thanks, that was exactly what I was looking for!