MDAC 2.6 and XML???

[desimonp at iname dot com]

I am using MS Access 2000.

Does MDAC 2.6 generating an XML sorted and totaled?  For example:


Col1    Col2    Col3
_______________
Val1    Val2    Val3
Val1    Val2    Val3

(Sort on Val3)  Total of Val3

Is the above result possible with MS Access 2000 Select statement?

Hopefully, it would then be possible to get an XML like the following

<root>
<sort1 total="10.00">
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
</sort1>
<sort2 total="20.00">
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
<Row Val1="something" Val2="somethingelse" Val3="somethingelse" />
</sort2>
</root>

Thanks..

Peter

--

++++++++++++++++++++++++++++++++++++++++++++++
Peter DeSimone

Email Address: desimonp@iname.com
New Email Address:  peter@desimone.com
Web Address: Http://www.bigfoot.com/~desimonp
New Web Address:  http://www.peter.desimone.com


ICQ:   20177836
AOL Instant Messenger:   Peterdesi1

++++++++++++++++++++++++++++++++++++++++++++++



---------------------------------------------------
Get free personalized email at http://www.iname.com


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list