<div>
Use 20 &nbsp;question mark characters instead of single asterisk.
</div>


<div>
if its XML you would be much better searching via the XML document Object...then you wouldn't have to worry if its 20 or 19 or 21 characters...much more robust
</div>


Ready to explore

Scott S

<div>
<div class="content wysiwyg-content fr-view">
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<br><br>Like '*' &amp; [Forms]![concept_entry]![concept_id_2] &amp; '*'
</div>
</div>



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] & '*'

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).