Avatar of Scott S
Scott S
Flag for United States of America

asked on 

Want to collect X number of characters before and after in XML file search

I have a query that looks at XML file for question numbers, What I would like to do is collect the 20 characters before the entry and the 20 after the entry, this is all text search the query I currently use is below

Like '*' & [Forms]![concept_entry]![concept_id_2] & '*'
Microsoft AccessXML* ms access query* Access 2019

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon