Hello All,

some years ago, I worked a lot with BaanOle to produce Word-documents, Excel-Sheets or e-mails.

Now, I have a new Project and have a Sql-Befehl like

select cuno, sum (amth), sum (dc3h), sum (dc2h) from tfacr200 group by cuno

The problem is, that I know no more how to read the sums in Visual Basic program.

Best I can say is look at this thread (http://www.baanboard.com/baanboard/showthread.php?t=14778&highlight=visual+ole) and follow the links. You might have to play with it a bit to see how to retrieve a sum value.