Combining columns from multiple tables/queries into one?

[ggranger007]

Is there a way to pull the results from several queries/tables into one table/query and only compare it to one variable?

For example, I have an Excel spreadsheet that is set up with every PO number available. The other fields in the spreadsheet may contain data or they may be blank.

PO | Date Created | Date Received
1 11/5/1955 11/5/1985
2
3 8/6/7530 9/8/7530
4
5 ----------------- 12/20/05
6 1/1/1985
7 1/1/1980
8 ----------------- 12/21/05
9 ----------------- 12/21/05


10

Is there any way to pull all the data from "Date Created" but only have it compare the table's relationship with the PO number and not also the "Date Received" column?

[ggranger007]

Mostly solved with a LEFT join on the PO data. I have several other fields that I believe need to have their relationships reworked to get the results I am looking for.