Dlookup zip codes in two different tables

[rplohocky]

I am trying to write a basic dlookup expression in a query. The lookup will look at

<code>
=DLookUp("[GARAGING ZIP / POSTAL CODE]","[tbl Idle Vehicles]",[GARAGING ZIP / POSTAL CODE]=[zip_code],[tbl Zip Code Data])
<code/>

In the query it will look in [tbl Idle Vehicles] in column [GARAGING ZIP / POSTAL CODE] to match what's in [tbl Zip Code Data] in column [zip_code].
This seems to be an easy lookup but I can't get this work. I have syntax errors every time I save it. Please, any help would be greatly appreciated!

 

[xenou]

Hi, you might have to provide some sample data. It isn't clear what you are trying to do, although I can verify that the syntax looks bad.