This works:
=DLookUp("[balance]","[t_daily_balance]","[tdate]=[Text37]")
Both this:
=DLookUp("[balance]","[t_daily_balance]","[tdate]='DateAdd("d",-1,"[Text37]")'")
and this:
=DLookUp("[balance]","[t_daily_balance]","[tdate]=DateAdd("d",-1,"[Text37]")")
evoke the error message:
"The expression you entered contains invalid syntax.
You may have entered an operand without an operator."
Can anyone put me right?