DLookUp or not??

[pensived]

Hello Everyone,

I'm trying to get a Dlook up to compare a 3 character long text string in one column in a query to a column in an unrelated table and if they match to return the word "Match"

Is Dlook up the wrong solution?

Table name "Altos" Table Column "AlCode"
Query Field Name "Altos1"

I'm stumped

Thank you for your help in advance

 

[plog]

Yes it is the incorrect method. You should LEFT JOIN the table to the underlying datasource field.

 

[pensived]

Awsome! Of course. Worked like a charm. thanks