Access

Hi Hazel

Thanks for your question

The closest function that I can find is DLookup, where D stands for domain.

It finds a value maching specified criteria in a specified field in a specified table. It can be used in a macro, query or calculated control on a form or report.

It has the following arguments.

expr - The field value you wish to return

Domain - The table containing the field

Criteria - An expression that limits the data to be returned

an example would look something like this

DLookup("[FirstName]", "Contacts", "[ContactID] = 3")