Jan 17, 2012 · You could use the VBA Split () function. You give it a string and tell it what to use as the delimiter; it returns an array of substrings. In your case, it seems you want the second substring, and since the array numbering is zero-based: Split("NWST/330/23/WT6", "/")(1)

The Split () function splits a string into an array of strings. Required. The string to split. Optional. The separator used to split the string. The default is a space character. Optional. The number of strings to be returned. The default is -1, which returns all strings (splitted) Optional. The type of string comparison.

Aug 5, 2019 · You have to create your own Split() function to wrap the functionality. Try something like: Public Function SplitIt(strValues As String, strDelim As String, intPart As Integer) As String. Dim arSplit As Variant. arSplit = Split(strValues, strDelim) SplitIt = arSplit(intPart - 1) End Function

How to use the Split function in a query in Microsoft Access.

Mar 2, 2022 · If you setup a Table1 and a Table2 with the same field names, you can run this function to do it for you - it basically loops through Table1 records, splits the Applications List into multiple fields and then inserts new records for each field. Const DATA_SEPARATOR As String = "," Dim qdf As DAO.QueryDef.

Mar 25, 2020 · I am trying to split values from a query, from one column into two. The column has GPS coordinate that I want to split into two, one for lat and one for long. I would greatly appreciate your help. Here is an example: From:

Mar 11, 2014 · I want to take the USSenators field, which contains data like (below) and split it into USSenator1 and USSenator2 fields, respectively: THE PROBLEM. I've tried a few different Access SQL queries... both (below) when executed, give the error message. Invalid use of '.', '!', or ' ()'. in query expression 'Split (USSenators & ";", ';') (0'.

Nov 19, 2020 · For the VBA code, then you can do something along these lines: Dim rst As DAO.Recordset. Dim strSQL As String. strSQL = "SELECT * from tblFood2'" Set rst = CurrentDb.OpenRecordset (strSQL) Do While rst.EOF = False. rst.Edit. rst!MyColumnName1 = Split (rst!SourceColumn, "/") (0) rst!MyColumnName2 = Split (rst!SourceColumn, "/") (1)

Sep 23, 2011 · The Split Form View function allows the user to update records by locating the details in Datasheet View and updating them in Form View, all on the same screen. It is one of the many useful features of Access 2007 that makes learning how to use it a lot less daunting than it may appear at first.

Creating a split form is very easy, as it’s listed within the regular forms. We select the table we want to work with, go to the Create tab->Forms->More Forms, and click Split Form. The result is to show the data from the table in two ways.