Not all data being pulled with queries

[joedean6]

Hey everyone,



I am new to access and need some help!

I have two sets of data I am trying to "combine" through queries. One is shipment data and the other is shipment costs. Now, I was able to create a relationship through the Shipment ID's so I can run the query, but not all the shipments are being returned. I believe this is because I wasn't invoiced on some shipments, so that shipment ID never showed up in the cost report I run. Now, my question is, how can i get the query to pull all the shipment data even if I was not invoiced yet?

Any help would be appreciated!

[orange]

Tell us about your database in simple business terms (no access jargon). What do the tables represent? How are the tables related?
What exactly do you want the query to do?
Show us the sql for your query.

[joedean6]

One Table is Shipment history. The other table is the costs related to the shipments.

What I want is for all the shipment data to be shown even if there are no costs related to it yet.

SQL:
SELECT [jan ser].*, BAF.[Transfer Amount], [Transfer Amount]/[Total Miles] AS [Transfer CPM], BAF.[Transfer Fuel], BAF.[Invoice Amount], BAF.[DefEst Freight], BAF.[Actual Freight], BAF.[Estim Freight], BAF.[Freight - Congestion], BAF.[Freight - Detention], BAF.[Freight - Expedited], BAF.[Freight - Fuel Surch], BAF.[Freight - Layover Ch], BAF.[Freight - Line Haul], [Freight - Line Haul]/[Total Miles] AS [SAP CPM], BAF.[Freight - Lumper (Un], BAF.[Freight - Miscellane], BAF.[Freight - Prot Heat], BAF.[Freight - Redelivery], BAF.[reight - Stop Off C], BAF.[Freight - Truck not], BAF.[Freight Expense], BAF.[Sales/Case]
FROM [jan ser] INNER JOIN BAF ON [jan ser].[Shipment ID] = BAF.SID;

[orange]

Review Left Join

[joedean6]

Got it to work! Thanks!