DLookUP Syntax on MS Access
Posted on 2011-03-11
I have an Access report that has an Assembly Reference field, for which I would like show the appropriate Part Description. The Assrembly Reference field is a look up from a table of Part Numbers and Part Descriptions.
Going through the MS Help file it looks like I need a DLOOKUP function but I can't seem to get the syntax right. I suspect the use of the word FORMS isn't going to help given I am applying it to a Report! MS Help doesn't seem to consider this.
The syntax I have used is:
=DLookup ("[Field I want to return]", "Table in which return field is found", "[Field in return table that is to be compared to Assembly Ref field] = " & Forms![Assembly Ref Table]!Assembly ref field)
I hope this makes sense to someone? I am an advanced user only!