Operations with database result properties

[Federico Moschini [328594]]

I would like to sum some fields from database result properties. Is this
possible and How.?

Thank you for your kind attention.

Federico

 

[Kathleen Anderson [MVP - FP]]

You could add a second DRW to the page with same criteria as the first and
sum the fields like this:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#sum

 

[Federico Moschini [328594]]

Thank you but where I have to insert the line suggested by you.

Could you give me an example ?

Thank you.
Federico

 

[Kathleen Anderson [MVP - FrontPage]]

Once you've run the wizard to create the second DRW, then you can start it
again, select custom query, and modify the SQL.

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

 

[Federico Moschini [328594]]

Thank you. It's correct. Now last think.

It sum all the amount in the SQL. I need that sum up only row of same
OrderId as first DRW.

How to do it?

I have tried to insert also WHERE (IdOrdCli = IdOrdCli) but no effect.

Thank you again.

Federico