Using a Field Value to set the Field you want to select in a query.

[aarotech]

I have a table (Data) that has field's that are named with numbers (10,13,15,17, etc.).



I want to set up a expression that uses a field value from another table to select the field mention above.

This is the way I thought to do it but dosn't work.
example:

Calc_Data: [Depr]![[Equip_Codes]![Life]]

Depr is the table
Table (Equip_Codes) field (Life) is where I want to get the value to select the Field in the above the table (Data).

[June7]

Don't understand. You identify 3 tables - Data, Depr, Equip_Codes. Reference [Depr]![[Equip_Codes]![Life]] doesn't make sense.

Maybe:

SELECT *, DLookup("[" & [Life] & "]", "Depr", "criteria to determine which record to get value from") As Calc_Data FROM [Equp_Codes];