hi,
Can I use SUM in query of tools module?

Jeffers

Check the following link,

http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_select

I hope it helps you

- Hiba

Hiba,
I think the SUM can be used in the script.
But in the Query, I don't know how to use it.

Jeffers

Hi Jeffers

What exactly do you want to achieve? Which table in the Tools module do you wish to query, and which field needs to be summed?

We use after.fields or after.report in the report of the query.
There we use the Aggregate Function "Total".
Works fine for us.

But it should be possible to use a simple sum function in the query itself.
For details please refer to the session help.
I attached our help as pdf.

hi,
Can I use SUM in query of tools module?

Jeffers

You can use SUM in a query like :

select sum(tdsls041.amta),
tccom010.nama,
tccom010.cuno
from tdsls041, tccom010
where tdsls041.cuno refers to tccom010
group by tccom010.nama, tccom010.cuno
order by tdsls041.amta desc
as set with 10 rows


TOP TEN CUSTOMERS for XLS OLE.

Regards