Solved Query Column Total (1 Viewer)

Reshmi mohankumar

Registered User.
Local time
Tomorrow, 03:37
Joined
Dec 5, 2017
Messages
65
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..
 

arnelgp

error reading drive A:
Local time
Tomorrow, 06:07
Joined
May 7, 2009
Messages
9,273
How is that is the field a Calculated?
 

Reshmi mohankumar

Registered User.
Local time
Tomorrow, 03:37
Joined
Dec 5, 2017
Messages
65
Closing units: [opening units]+[purchase units]+[return units]-[sales units]
Here closing units is calculated field on query
 

arnelgp

error reading drive A:
Local time
Tomorrow, 06:07
Joined
May 7, 2009
Messages
9,273
cast them to Double?

Closing units: CDbl(Nz([opening units], 0))+CDbl(Nz([purchase units], 0))+CDbl(Nz([return units], 0))-CDbl(Nz([sales units], 0))
 

The_Doc_Man

Happy Retired Curmudgeon
Local time
Today, 17:07
Joined
Feb 28, 2001
Messages
16,760
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...
First question I have for this is whether that integer field in the table has been scaled by a factor of 10, because it is possible to do things like that. What are the properties of that INTEGER field to which you make reference?
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom