VatRate01: Dlookup(" [VatRate01] ","q02VatRate","VatCode01=" & VatCodePurchases01 AND #" & Format([DocumentDate01]), "yyyy-mm-dd") & "# Between [StartDate11] And [EndDate13]")
I use a very similar expression elsewhere in my system and it works perfect. You may see the error it gives me here on the image. “The expression you entered has an ivalid date value”. The format I mainly use for dates is 14-Apr-2018.
You may see in this lower line I typed the “Double Qoutes” are tilted when I type in MS Word. But the top line was not typed in MS Word. Why does Word type it tilted? When I copy this tilted quotes to Access, it errors.