It would really help if you used real field/table names....
But try
Code:
SELECT TableB.PO_DT, TableB.[PO_NUm] AS [PO Num], TableA.fuel_charges
FROM TableB, TableA
WHERE (((TableA.effective_Date)<=[PO_DT]) AND ((TableA.expiry_date)>=[PO_DT]))
ORDER BY TableB.PO_DT, TableA.effective_Date;
My results from the query:
PO_DT |
PO Num |
fuel_charges |
1/1/2021 |
001 |
$20.23 |
1/2/2021 |
002 |
$20.23 |
1/3/2021 |
003 |
$20.23 |
1/4/2021 |
004 |
$20.23 |
1/5/2021 |
005 |
$20.23 |
1/6/2021 |
006 |
$20.23 |
1/7/2021 |
007 |
$20.23 |
1/8/2021 |
008 |
$20.23 |
1/9/2021 |
009 |
$20.23 |
1/10/2021 |
010 |
$20.23 |
1/11/2021 |
011 |
$20.23 |
1/12/2021 |
012 |
$20.23 |
1/13/2021 |
013 |
$20.23 |
1/14/2021 |
014 |
$20.23 |
1/15/2021 |
015 |
$20.23 |
1/16/2021 |
016 |
$20.23 |
1/17/2021 |
017 |
$20.23 |
1/18/2021 |
018 |
$20.23 |
1/19/2021 |
019 |
$20.23 |
1/20/2021 |
020 |
$20.23 |
1/21/2021 |
021 |
$20.23 |
1/22/2021 |
022 |
$20.23 |
1/23/2021 |
023 |
$20.23 |
1/24/2021 |
024 |
$20.23 |
1/25/2021 |
025 |
$20.23 |
1/26/2021 |
026 |
$20.23 |
1/27/2021 |
027 |
$20.23 |
1/28/2021 |
028 |
$20.23 |
1/29/2021 |
029 |
$20.23 |
1/30/2021 |
030 |
$20.23 |
1/31/2021 |
031 |
$20.23 |
2/1/2021 |
032 |
$19.45 |
2/2/2021 |
033 |
$19.45 |
2/3/2021 |
034 |
$19.45 |
2/4/2021 |
035 |
$19.45 |
2/5/2021 |
036 |
$19.45 |
2/6/2021 |
037 |
$19.45 |