replace abreviation with full name from different table 1

[julesverne]

I could not find the answer to this simple problem in the "threads".

I have a report based on table "bib"
Table "bib" has a field "first", a 1 character abreviation.
Table "first" has 2 fields... the above abreviation in a field called "first" (yes same in both tables), and the full name in field "place"

How do I get the full name "place" to print on my report instead of the abreviation?

I have attempted :

 =DLookUp("[PLACE]","FIRST","[FIRST]='" & [FIRST] & "'")

but I get a "#error".
(the above should say "First American" or "First English" if it works correctly!)

Thank you for your time... Andrew

 

[JoeMiller]

Add the fullname table to the query feeding your report, make sure that a relationship line is drawn between the abbreviation fields, drag the fullname down to the grid and run the query. You should have the fullname field now populated based on the related abbreviation in each table. Now add the new field to your report, voila!

HTH Joe Miller
joe.miller@flotech.net

 

[julesverne]

Thank you for the wonderfully simple answer.
The step I had been missing was the "dragging" of the full name field to the grid in the query.

Thank you again for the quick (and correct) reply.
... Andrew

 

[JoeMiller]

Glad I could help..

Joe Miller
joe.miller@flotech.net