<div>
<div class="content wysiwyg-content">
I'm using someone's table that has some sales goals fields set up, like U2008MAN (for machine goal in 2008), U2008PART (for parts goal in 2008), U2007MAN, etc. I want to set up a query to get the current year and previous year goals. Is there a way to build the field names in the query, along the lines of:<br />
CurrMachineGoal:[&quot;U&quot; &amp;&nbsp;year &amp;&nbsp;&quot;MAN&quot;]? <br />
(I can do the year part, just don't know if something like this is possible)
</div>
</div>


I'm using someone's table that has some sales goals fields set up, like U2008MAN (for machine goal in 2008), U2008PART (for parts goal in 2008), U2007MAN, etc. I want to set up a query to get the current year and previous year goals. Is there a way to build the field names in the query, along the lines of:
CurrMachineGoal:["U" & year & "MAN"]? 
(I can do the year part, just don't know if something like this is possible)

dynamic field name in a query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.