I am trying to do a dlookup in a query, using Access 2002. In the criteria field I want to use a field from another query, but it won't accept it. I know you can do this with a forms field...ie forms![formname]![field] but how would I do this with a query field XXXX![queryname]![field] but I can't figure out what goes at the first bang.