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@xxxxxxxxx
New Email Address:  peter@xxxxxxxxxxxx
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