Dlookup in a Query

Hi
I am using Access 97. I have created a query called query1. In this query I read values off a table not included in my query. One of the criterias I need to use is a field inside my query. I have the following expression in one of the query fields:HUB_RATE: DLookUp("MIN_RATE","KRG_HUB_RATE","HUB_ID = [KRG_SPECIAL_RATE].[ZONE_HUB_ID]"). The [KRG_
SPECIAL_RATE].[ZONE_HUB_ID] is the criteria I am trying to use. Access keeps on returning a "...Can't find the name..." error. All table and field names are correct. Please help !!!!