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.
very good keep uploading
Thank you, I will!
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.
Great question! Yes you can: th-cam.com/video/vQX0taPQLB0/w-d-xo.html