<div>
how are the label information stored in the table? does it have id to distinguish them from each other?<br />
<br />
post sample data...<br />
<br />
you can create a function to get the correct label,<br />
by passing a parameter to the function 
</div>


how are the label information stored in the table? does it have id to distinguish them from each other?

post sample data...

you can create a function to get the correct label,
by passing a parameter to the function

<div>
<div class="content wysiwyg-content">
I have a report that is based on a Query. &nbsp;I have a separate table that contains the Page header labels I want to use. &nbsp;How can I query the separate table (not related to the content of the report) to set the Caption value of the label?
</div>
</div>


I have a report that is based on a Query.  I have a separate table that contains the Page header labels I want to use.  How can I query the separate table (not related to the content of the report) to set the Caption value of the label?

MS Access - Setting a Report Header label value

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.