Subject Multiplication and Data Types
Author radevojvodic
Hi all,

Is there anyone that could give me a detailed explanation on
multiplication of different data types. data type of result of this
operation is not very clear to me.

Another problem that i need solution for is:

I have a table with items, prices and quanities. Multiplication of
last two and summing gives me a amount od sold items. At the end of
the day i am decreasing my stock by summing all quantities grouped by
items and put that in a different table for stock tracking. The
problem is that multiplication of prices(same as in the first table)
and quantities gives me different amount then in the first case.

How to solve this (which data type, precission etc.)

Thans in advance