Hi Cameron, It's not possible to make cumulative sums in standard SQL. Or very difficult at least ...
But your problem inspired me to extend my small RRtools into handling alphanumeric data. I've included a new "Cumulative update" feature, which should work for you. You can find the link to download RRtools on this page: http://hjem.get2net.dk/lars-online/download/ Enjoy. Best regards / Med venlig hilsen Lars V. Nielsen Odense, Denmark ----- Original Message ----- From: "Cameron McGregor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 18, 2002 10:17 PM Subject: MI-L MapInfo Cumulative Total > Hi There, > I am trying to populate and empty numeric field in a table with a cumulative > total of another field in the same table. I have the table sorted the way I > want the cumulative total to run. Any ideas how i can do this either in a > query or a command?! Thanks in advance > > i.e. > Field01 Cumulative > 100 100 > 200 300 > 150 450 > 250 700 > 50 750 <http://www.experts-exchange.com/Databases> > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3651
