Return The Value In A Specified Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 18 Jul 2007 23:36 GMT

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

Reply to this Message

JohnC - 19 Jul 2007 00:04 GMT

Easiest but worse case because it is the slowest is to use dlookup

> Field F in a table contains any one of the names of the fields in a table.
> For example:
[quoted text clipped - 11 lines]
>
> Steve

Reply to this Message

Steve - 19 Jul 2007 00:57 GMT

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

> Easiest but worse case because it is the slowest is to use dlookup
>
[quoted text clipped - 17 lines]
>>
>> Steve

Reply to this Message