<div>
Let me please try and rephrase in this manner - I would like to have the flexibility to change column names across multiple tables generated by the database, that may have one or more of the columns renamed.<br />
<br />
Similar to updating values in a column. If I am updating values in Table A, based on values in Table B, Table A may not have all the values in Table B, but what is the same will be updated.<br />
<br />
Hope this makes sense.
</div>


Let me please try and rephrase in this manner - I would like to have the flexibility to change column names across multiple tables generated by the database, that may have one or more of the columns renamed.

Similar to updating values in a column. If I am updating values in Table A, based on values in Table B, Table A may not have all the values in Table B, but what is the same will be updated.

Hope this makes sense.

<div>
<div class="content wysiwyg-content">
I have a series of tables I will be generating. Not all date renames will be included in the tables generated, but across all tables, the renamed columns will be used.<br />
<br />
Example<br />
<br />
Table A: Columns 1, 2, 3<br />
Table B: Columns 2, 3<br />
Table C: Column 1<br />
<br />
Renames<br />
Column1 - Column11<br />
Column2 - Column22<br />
Column3 - Column33<br />
<br />
Is there a way to for me to create one look-up query, where each of Tables A -C will only have the columns that are contained within it renamed?<br />
<br />
Thank you.
</div>
</div>


I have a series of tables I will be generating. Not all date renames will be included in the tables generated, but across all tables, the renamed columns will be used.

Example

Table A: Columns 1, 2, 3
Table B: Columns 2, 3
Table C: Column 1

Renames
Column1 - Column11
Column2 - Column22
Column3 - Column33

Is there a way to for me to create one look-up query, where each of Tables A -C will only have the columns that are contained within it renamed?

Thank you.

Access - lookup method for renaming columns

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.