Reshmi mohankumar
Registered User.
- Local time
- Today, 18:45
- Joined
- Dec 5, 2017
- Messages
- 101
Hi,
I had a database with some tables . I created a select query from different sub queries (Which are grouped by Product ID and summing of [Units]).
I have 5 Subqueries with same properties . all individual query getting data correctly and also main query also showing the data correctly.
But in a main query a new calculated field is not showing actual results. actually datatype of [Units] is "number>Double>2 digits". When i have decimals the result will be fine. But when i have integer value in table field the result will be multiplied with 10.. Example if manual calculation is 155 , The query calculated field result will be 1550...
Thank you for your best help..
I had a database with some tables . I created a select query from different sub queries (Which are grouped by Product ID and summing of [Units]).
I have 5 Subqueries with same properties . all individual query getting data correctly and also main query also showing the data correctly.
But in a main query a new calculated field is not showing actual results. actually datatype of [Units] is "number>Double>2 digits". When i have decimals the result will be fine. But when i have integer value in table field the result will be multiplied with 10.. Example if manual calculation is 155 , The query calculated field result will be 1550...
Thank you for your best help..