i read the thread entitled "Convert Field Value String to Actual Field in Expression"
It appeared that the final solutions got moore complex not less complex
MY PROBLEM IS:
1. get a value from one table as a string "C"
2. lookup the value of a field in a TABLE2 "CD"
where the field name = the value of field in TABLE1
I CAN GET THIS USING DLOOkUP, BUT...
BobM
Last Activity: Oct 22 '06, 07:14 PM
Joined: Oct 22 '06
Location:
-
DLOOKUP vs FIND For Values as Field names
-
dlookup or find methods for fileds using balue for field name
i read the thread entitled "Convert Field Value String to Actual Field in Expression"
It appeared that the final solutions got moore complex not less complex
MY PROBLEM IS:
1. get a value from one table as a string
2. lookup the value of a field in a second table
where the field name = the value of field in table 1
I CAN GET THIS USING DLOOkUP, BUT NOT BY FIND METHOD... -
dlookup or find methods for fileds using balue for field name
i read the thread entitled "Convert Field Value String to Actual Field in Expression"
It appeared that the final solutions got moore complex not less complex
MY PROBLEM IS:
1. get a value from one table as a string
2. lookup the value of a field in a second table
where the field name = the value of field in table 1
I CAN GET THIS USING DLOOkUP, BUT NOT BY FIND METHOD...
No activity results to display