How to eval a field name contained in another field in an Access Query?
<p>I need to create a long list of complex strings, containing the data of different fields in different places to create explanatory reports.
The only way I conceived, in Access 2010, is to save text parts in a table, together with field names to be used to compose the string to be shown (see line1 expression in figure). Briefly:</p>

<pre><code>//field A contain a string with a field name:
A = "[Quantity]"
//query expression:
=EVAL(A) 
//return error instead the number contained in field [Quantity], present in the query dataset
</code></pre>

<p>I thought doing an EVAL on a field (A), to obtain the value of the field (B) which name is contained in field A. But seems not working.
Any way exist?</p>

<p>Example (very simplified):
<a href="http://i.stack.imgur.com/nGSdv.jpg" rel="nofollow">Sample query that EVAL a field containing other field names to obtain the value of the fields</a></p>

<p>Any Idea? 
PS: Sorry for my english, not my mothertongue.</p>