records in one table without corresponding record in another

[Atlascycle]

What I am looking to do is daily all of the parts that are running in every machine is stored in the Production_Partial table. I need to run a query to pull the days part numbers and if the part number has ran in that machine before pull the Takt Time(parts per hour) from the Takt_Times Table. If there is not a record in the Takt_Time Table I need the record for the day to still return in the query as to populate the Takt_Time table Via a Form.
I currently have 2000 different part numbers and 39 machines. all of the part numbers cannot run in all of the machines but there are parts that can run in more than one machine.

This is the SQL view for the Query:
SELECT Production_Partial.PressID, Production_Partial.CustProdID, Production_Partial.Date, Takt_Times.FK_PressID, Takt_Times.TaktTime
FROM Takt_Times INNER JOIN Production_Partial ON Takt_Times.FK_PressID = Production_Partial.PressID
WHERE (((Production_Partial.Date)=Date()-4));



Any direction would be greatly Appreciated.

Thank You
Jason

[orange]

You need to design your tables before attempting to run queries.
If you are seeking advice/assistance from the readers , you are going to have to tell us
-WHAT your business is; (what does your company do?)
-WHAT are the things involved;
-HOW do these things relate to each other;
-WHAT Tables and Relationships do you have now?

[Atlascycle]

Attached is the database. The Tables i am looking to use are the Production_Partial and the Takt_times.

will post more information shortly.

Jason

[Atlascycle]

What i am looking to do is create a daily report to track if the machines are making the production goal. There is a SCADA software that saves the information to the production partial table. The information in the takt time table will be slowly manually entered but if the part has ran in this machine before then i would like it to automatically retrieve the takt time but still return the machines that do not have a takt time for the specific machine and part combination.

[Atlascycle]

Ok I modified the join Properties in the Query and now have the query returning all of the records.