DLookup in a Query

[Don]

I want to use a DLookup in a calculation in a query, but I can't figure out
how to write it. The "expr" is ITEM_DESCRIPTION and the "domain" is
tblITEM_MASTER and the "criteria" is ITEM_NO which is a field from the same
query I want to write my expression in. The underlying table for the query
is tblMEAL_SUB.

I have a hard time with dLookup because it seems to me there are a hundred
ways to write it, depending on conditions.

Any help would be appreciated.

 

[fredg]

I want to use a DLookup in a calculation in a query, but I can't figure out
how to write it. The "expr" is ITEM_DESCRIPTION and the "domain" is
tblITEM_MASTER and the "criteria" is ITEM_NO which is a field from the same
query I want to write my expression in. The underlying table for the query
is tblMEAL_SUB.

I have a hard time with dLookup because it seems to me there are a hundred
ways to write it, depending on conditions.

Any help would be appreciated.

If [Item_No] is a Number datatype:
DLookUp("[Item_Description]","tblItem_Master","[Item_No] = " &
[Item_No])


If, however, [Item_No] is a Text datatype field, then:
DLookUp("[Item_Description]","tblItem_Master","[Item_No] = '" &
[Item_No] & "'")

 

[Don]

That's exactly what I needed. I didn't account for a text field. Thank you.
--
Don Rountree

I want to use a DLookup in a calculation in a query, but I can't figure out
how to write it. The "expr" is ITEM_DESCRIPTION and the "domain" is
tblITEM_MASTER and the "criteria" is ITEM_NO which is a field from the same
query I want to write my expression in. The underlying table for the query
is tblMEAL_SUB.

I have a hard time with dLookup because it seems to me there are a hundred
ways to write it, depending on conditions.

Any help would be appreciated.

If [Item_No] is a Number datatype:
DLookUp("[Item_Description]","tblItem_Master","[Item_No] = " &
[Item_No])


If, however, [Item_No] is a Text datatype field, then:
DLookUp("[Item_Description]","tblItem_Master","[Item_No] = '" &
[Item_No] & "'")