I can't seem to get the following to work. I'm trying to lookup the
information in a table and compare it to a query and return the vale in a
filed in the tabel. If this was excel I just to a vlookup and I'm done, but
there is no vlookup in access, HELP.

iff( [CVR 8TH RUN]![Expr10] = [All Stations]![STN CD] , [All
Stations]![Profit Center] ,"n/a")

or

dlookup( [All Stations]![STN CD] ,Profit Center", [CVR 8TH RUN]![Expr10] )

I'm not exactly clear where you are trying to do this...

Are you trying to get a value looked up to show up in a table? If so, stop!

Tables (in Access) are great places to store data, but don't work well to
display it.

Forms in Access work great to display data, and give you a way (via
listboxes and comboboxes) to look up values from another table.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"pgarcia" <(E-Mail Removed)> wrote in message
news:57658C75-BE68-4FC2-94A2-(E-Mail Removed)...
>I can't seem to get the following to work. I'm trying to lookup the
> information in a table and compare it to a query and return the vale in a
> filed in the tabel. If this was excel I just to a vlookup and I'm done,
> but
> there is no vlookup in access, HELP.
>
> iff( [CVR 8TH RUN]![Expr10] = [All Stations]![STN CD] , [All
> Stations]![Profit Center] ,"n/a")
>
> or
>
> dlookup( [All Stations]![STN CD] ,Profit Center", [CVR 8TH RUN]![Expr10] )