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?