dlookup function

[Guest]

Hi,
I am looking for a function in MS Access, similiar to the one used in Excel,
in order to derive the values for the fields by simply entering their either
ID number or any identical value. In Excell, the hlookup & vlookup function
are very useful to do this. But how about in Access?
Is there anyone who gives me a hint how to do it Access? I appreciate the
reply with an example...

 

[Douglas J. Steele]

Take a look at DLookup in the Help file.