<div>
Dim arr<br />
dim Myservername as string<br />
dim MyUsername as string<br />
arr= split(mid(yourfieldnameher<wbr />e,3), &quot;/&quot;)<br />
<br />
MyServername = arr(0)<br />
MyUsername = arr(3)
</div>


Dim arr
dim Myservername as string
dim MyUsername as string
arr= split(mid(yourfieldnamehere,3), "/")

MyServername = arr(0)
MyUsername = arr(3)

<div>
Sorry should have been more specific on what I was looking for. &nbsp;I created a 'server' and a 'username' field in the table... so I was just looking for how to populate this with an update query run against the table.
</div>


Sorry should have been more specific on what I was looking for.  I created a 'server' and a 'username' field in the table... so I was just looking for how to populate this with an update query run against the table.

<div>
didn't need to do it afterall, but thanks.
</div>


didn't need to do it afterall, but thanks.

<div>
<div class="content wysiwyg-content">
I have thousands of records in a single field within a table in the following format<br />
<br />
\\SERVERNAME\C$\DOCUMENTS AND SETTINGS\USERNAME<br />
<br />
The actual data has different values for SERVERNAME AND USERNAME then shown above. I would like to extract the SERVERNAME &nbsp;and USERNAME values into their own fields.<br />
<br />
How to do?
</div>
</div>


I have thousands of records in a single field within a table in the following format

\\SERVERNAME\C$\DOCUMENTS AND SETTINGS\USERNAME

The actual data has different values for SERVERNAME AND USERNAME then shown above. I would like to extract the SERVERNAME  and USERNAME values into their own fields.

How to do?

Need help separating data in a string

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.