Converting Access query to XML

[cotec]

I have an ASP application that needs to create one of 7 different reports. I am trying to create XML documents and use XSLT to display them. However, I'm having trouble figuring out exactly how I would go about creating the XML document from my SQL query. Does anyone know of an easy way to convert the Access query's results into an XML document in ASP? Or is there a special keyword I can use in the Access query that will automatically do this for me? A co-worker had told me that SQLServer has the "FOR XML" keywords that automatically return an XML string, so I was wondering if there was something similar in Access...


Chris