Lookup Values

[Úna Murphy]

Hi

I wondering if someone can help me solve a problem I seem
to be having getting an expression to work. What I am
trying to do is something very similar to lookup tables
within Excel but i can not get my head around transferring
this into Access. The purpose of the DB is to show what is
required based on the information entered within a record.
There is a field value when entered determines the outcome
of the following fields e.g. field no 2 lookups up field
no 1 value and compares this value with the values in
table x and enters the result in field no 2.

Can this be done within Access? If so how.
I would really appreciate your help.

Many thanks

Úna

 

[Ken Snell [MVP]]

Not fully clear about your setup, but take a look at the DLookup function in
ACCESS Help files. It allows you to obtain a value from a field in a table
or query based on a criterion.
--

Ken Snell
<MS ACCESS MVP>

Hi

I wondering if someone can help me solve a problem I seem
to be having getting an expression to work. What I am
trying to do is something very similar to lookup tables
within Excel but i can not get my head around transferring
this into Access. The purpose of the DB is to show what is
required based on the information entered within a record.
There is a field value when entered determines the outcome
of the following fields e.g. field no 2 lookups up field
no 1 value and compares this value with the values in
table x and enters the result in field no 2.

Can this be done within Access? If so how.
I would really appreciate your help.

Many thanks

Úna