data manipulation

[Guest]

does access have the capability to perform a function similar to a v-lookup
function in excel, if so, how does it work

 

[Guest]

Take a look in the Help file for the Dlookup function. I think this will
give you what you are looking for.

 

[John Vinson]

On Wed, 26 Apr 2006 13:50:01 -0700, S Hendry <S

does access have the capability to perform a function similar to a v-lookup
function in excel, if so, how does it work

There is a DLookUp function - but in a relational database, you may
not need any function AT ALL, instead using a Query joining the
relevant tables.

Could you explain your table structure, and what you are trying to
accomplish? This may be simpler than you expect...

John W. Vinson[MVP]