Is there an easy way in access, to extract text mid-string and populate it into a new field in a table. I have a table with an excess of 1,000,000 rows, and one field (FullName), is essentially an UNC path from a file server, e.g. \\server\share\username . I basically need to extract the username section from that into a separate field as I need to do some group by and min/max stats on the field. There is a slight inconsistency in that some rows will have additional data in the path e.g. \\server\share\username\folder\doc1.docx, whereas at the start the rows are just \\server\share\username - its basically a recurse file inventory which would start with the usernames, then a more detailed breakdown of the files held within each simultaneously afterwards - but either way, I need to extract the username 'segment' from the string on every single row, regardless of format and wondering how best to do so.