Return The Value In A Specified Field

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Field F in a table contains any one of the names of the fields in a table.
For example:
ID F
3 MyFieldName

In record 3, MyFieldName has the value 13. Is there an expression that looks
at the name of the field in F and returns the value in that field? In this
example the expression would return 13.

For record 5, F might contain YourFieldName and YourFieldname in record 5
would have the value of 99. In this example the expression would return 99.

Thanks!

Steve
 
John,

Thanks for responding! How do you suggest writing the DLookup expression.
Keep in mind that the expression has to leek at field F to get the fieldname
from where to get the value. In my first example, the expression has to look
in the field, MyFieldName, to get the value for record three. That same
expression has to look in the field, YourFieldName, to get the value for
record five.

Steve
 
Back
Top