Forum Discussion

Tony2021's avatar
Tony2021
Steel Contributor
Apr 03, 2022

Between formula

Hello Experts,   I am trying to add a between condition to the following.  Rate2: Format(DLookUp("Rate","qryPricing","ID=" & [ProjID] & "[dte] between [DateStart] and [DateEnd]"),"Percent")   I ...
access
arnel_gp's avatar
arnel_gp
Steel Contributor
Apr 04, 2022
Which table does [dte] belongs? maybe:

Rate2: Format(DLookUp("Rate","qryPricing","ID=" & [ProjID] & " And " & [dte] & " between [DateStart] and [DateEnd]"),"Percent")
Tony2021's avatar
Tony2021
Steel Contributor
Apr 07, 2022
HI Arnel, just checking in with you. Let me know if you have another suggestion. Looking forward to your response.

Resources