Query Help Needed

[mak1176]

I'm trying to create a query that will pull information from multiple tables and another query. I am trying to report out every PO that is listed in tblRawMaterialReceiving. The issue is that the query will only report out those PO Numbers that are found in the qryFreightPerPound and not every PO Number from the Table. I basically want to show that if the PO Number does not have any frieght, it would report out as 0.00. And if it does have freight, it will report that cost.




Query is below.

[rzw0wr]

Are there records in the other tables?
Also take a look at your joins.
You are asking to show only records that are equal in the tables.


Dale

[mak1176]

Dale thanks that works! completely forgot about the joins!

Also yes there are records in the other tables.

Thanks again!

Are there records in the other tables?
Also take a look at your joins.
You are asking to show only records that are equal in the tables.


Dale