How can I add the XML Values in an Access field

[Guest]

I would like to query a database and add the values in a string of XML in a
particular field. Is there any way to do this using SQL?

 

[[MVP] S.Clark]

Access does not have the ability to do this in the SQL code.

Give a more detailed example, and maybe a suitable workaround can be found.