Hi, i watched your video trying to understand how to take a single field with text either side of a '\' symbol so the information can be split into two different fields as part of an update expression query in access. Do you have a similar video that touches on this topic?? - For example; Fullname field = John\Smith and i want to split it in an update query to a new field - 'First name' returning as 'John', and the second field 'Last name' returing from the query as 'Smith'. I need to be able to split by the left and right of the '\' symbol as the Char lenghts are never the same.
