I'm trying to write an expression to get a value from another table, using a value from a report. Here's my attempt:
=DLookUp("[activity_desc]","[ActivityCode]","[activity_cd] = activity_cd")
I'm trying to get the value from the field "activity_desc" in the table "ActivityCode", where the...