Result of double and integer multiplication

[SunTop]

Hello everyone,

If you but an expression in a query that performs multiplication between a field of type double and the result of another expression that is possibly of type integer, would you get the answer of type double or of type integer and how can you verify what type of data is the answer is stored in ?

[isladogs]

If done in a select query or function, the result will be a double.

However, if you are using an update query to calculate the result in a table field, the result will be in whatever datatype is used for that field.
If the field is an integer, the result will be rounded.