<div>
does the table &quot;&nbsp;Local_Config&quot; have a field corresponding to the Documents.ID field?<br />
<br />
SELECT Documents.ID, (SELECT Val FROM Local_Config WHERE Key = 'Repo' and Documents.ID=Local_Config.<wbr />ID) &amp;&nbsp;Documents.[Name] From Documents;
</div>


does the table " Local_Config" have a field corresponding to the Documents.ID field?

SELECT Documents.ID, (SELECT Val FROM Local_Config WHERE Key = 'Repo' and Documents.ID=Local_Config.ID) & Documents.[Name] From Documents;

<div>
Make sure the path includes &quot;\&quot; at the end. &nbsp;If it doesn't, you need to include one when you concatenate the path with the file name.
</div>


Make sure the path includes "\" at the end.  If it doesn't, you need to include one when you concatenate the path with the file name.

<div>
<div class="content wysiwyg-content">
I am building a query in MSAccess 2013. I have a Table containing the names of documents, and a different Table containing the path these Documents reside in. I would like a query that concatenates the path with the name of the document. Perhaps something like<br />

<pre><code id="code-10-28709334-1">SELECT Documents.ID, (SELECT Val FROM Local_Config WHERE Key = 'Repo') &amp; Documents.Name From Documents;</code></pre>
I think this is a basic SQL question that I just don't have the knowledge to answer.
</div>
</div>


I am building a query in MSAccess 2013. I have a Table containing the names of documents, and a different Table containing the path these Documents reside in. I would like a query that concatenates the path with the name of the document. Perhaps something like
(CODE)
I think this is a basic SQL question that I just don't have the knowledge to answer.

How lookup a value for TSQL 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.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.