Bring Value by Range

[soldat452002]

Hi,




I'm trying to bring over the Affiliation to my table tblStatus by Date Range.


Two Affiliations fall under the 2013 (10/1/2013-10/2/2013) and (10/3/2013-12/31/2013) How would achieve this?


My Code to bring Affiliation:


Affiliation: DLookUp("[Affiliation]","[tblAffiliation]","[TID] ='" & [TID] & "' And #" & [Exp] & "# Between [Eff] And [Exp]")




tblAffiliation
TID Affiliation Eff Exp
22764 BELA, INC 11/1/2008 10/2/2013
22764 INDIVIDUAL 10/3/2013 3/31/2014
22764 CONSULTING INC 4/1/2014 12/31/9999


tblStatus
TID Status Eff Exp Affiliation
22764 COMPLETE 1/1/2000 6/30/2012
22764 INACTIVE 7/1/2012 10/2/2013
22764 COMPLETE 10/3/2013 4/30/2014
22764 TMUTUAL 5/1/2014 12/31/9999