I have been trying to figure out how to use DLOOKUP to convert state abbreviations (ex. NY, NJ) into full state names (ex. New York, New Jersey) in a report I'm creating. I have two tables, one that has the data I'm building a report with (table name=USA), then another table that has a list of all state names and their corresponding abbreviation (table name=States). Here is what I have tried to use within the control source of my report:
=DLOOKUP("[FullName]","[States]","[Abbr]=[USA]![State]")