Lagervärdering valuta Euro

Skript:

SELECT Aitem As Artikel,Aname As Namn,Astockqty As Saldo,Acinprice As Pris,Astockqty*Acinprice As Summa FROM LagerWHERE Astockqty<>0 And Astocked=´J´ And Ahide<>´J´ And Acurcode=´12´ORDER BY Aitem

Ändra "Acurcode=´12´" till önskad valutakod.

Flagga:

SumCol(5)

Denna flagga summerar värdet i kolumn fem, Summa.