Date Condition

[noletwin1]

I have two tables I want to combine:
tbl_FYC_2016_Initial
tbl_FYC_Date

In tbl_FYC_2016_Initial it has a field, Cal_DT that will fall between or is equal to two fields fields in tbl_FYC_Date.
Beg_Date is field one that the Cal_DT should be greater than
End_Date is the field that Cal_DT should be less than
Rpt_Date is the field that I want to be displayed if a Cal_DT is between the dates

There are other fields that I want to combine from tbl_FYC_2016_Initial but will worry about that after I can get the correct date be there.

 

[noletwin1]

SELECT tbl_FYC_2016_Initial.CAL_DT, DLookUp("[Rpt_Date]","tbl_FYC_Date",[tbl_FYC_2016_Initial]![CAL_DT]>=[Beg_Date] And [tbl_FYC_2016_Initial]![CAL_DT]<=[End_Date]) AS Rptg_Mo_DT
FROM tbl_FYC_Date, tbl_FYC_2016_Initial;

I have tried this, but it isn't working.