<div>
@Jim, “FullPath: [Path] &amp;&nbsp;&quot;\&quot; &amp;&nbsp;[File] &amp;&nbsp;&quot;.&quot; &amp;&nbsp;[Extension]” worked. Thank you.
</div>


@Jim, “FullPath: [Path] & "\" & [File] & "." & [Extension]” worked. Thank you.

<div>
<div class="content wysiwyg-content">
I need help writing a query. There are three fields from three tables involved: File from the Files table, Path from the Paths table and Extension from the File Types table. The result of combining the three fields will look like the following:<br />
<br />
c:\images\image1.tif<br />
<br />
The full path and file information “c:\images\image1.tif” has to appear in a single record. Any advice about how write the query will be greatly appreciated.
</div>
</div>


I need help writing a query. There are three fields from three tables involved: File from the Files table, Path from the Paths table and Extension from the File Types table. The result of combining the three fields will look like the following:

c:\images\image1.tif

The full path and file information “c:\images\image1.tif” has to appear in a single record. Any advice about how write the query will be greatly appreciated.

MS Access 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.