In Excel I linked an Access query but some values are not shown correctly. Imagine I have TableA with these values:
Description | Value1 | Value2 | Value3 | Quantity
Bricks | 12.32 | 1.22 | 5.03 | 2
Wood | 12.22 | 1.1 | 5.55 | 1
Steel | 12.1 | 2.2 | 5.12 | 3
In a query, I have:
SELECT TableA.[Description], TableA.[Value1], TableA.[Value2], TableA.[Value3], TableA.[Value1]+TableA.[Value2]+TableA.[Value3] AS SumOfValues
FROM TableA
Then, in Access I have:
Description | Value1 | Value2 | Value3 | SumOfValues
Bricks | 12.32 | 1.22 | 5.03 | 18.57
Wood | 12.22 | 1.1 | 5.55 | 18.87
Steel | 12.1 | 2.2 | 5.12 | 19.42
But when I link that query from Excel, in Excel I have:
Description | Value1 | Value2 | Value3 | SumOfValues
Bricks | 12.32 | 1.22 | 5.03 | 18.57
Wood | 12.22 | 1.1 | 5.55 | 28.77
Steel | 12.1 | 2.2 | 5.12 | 148.12
i.e, the second row is calculated as 12.22+11+5.55 and the third row is calculated as 121+22+5.12
I tried to put 2 decimals in each value, but I couldn't. I tried Format([..], "Fixed") but it concatenates the values, it doesn't make a sum
What can I do?
Thanks
Description | Value1 | Value2 | Value3 | Quantity
Bricks | 12.32 | 1.22 | 5.03 | 2
Wood | 12.22 | 1.1 | 5.55 | 1
Steel | 12.1 | 2.2 | 5.12 | 3
In a query, I have:
SELECT TableA.[Description], TableA.[Value1], TableA.[Value2], TableA.[Value3], TableA.[Value1]+TableA.[Value2]+TableA.[Value3] AS SumOfValues
FROM TableA
Then, in Access I have:
Description | Value1 | Value2 | Value3 | SumOfValues
Bricks | 12.32 | 1.22 | 5.03 | 18.57
Wood | 12.22 | 1.1 | 5.55 | 18.87
Steel | 12.1 | 2.2 | 5.12 | 19.42
But when I link that query from Excel, in Excel I have:
Description | Value1 | Value2 | Value3 | SumOfValues
Bricks | 12.32 | 1.22 | 5.03 | 18.57
Wood | 12.22 | 1.1 | 5.55 | 28.77
Steel | 12.1 | 2.2 | 5.12 | 148.12
i.e, the second row is calculated as 12.22+11+5.55 and the third row is calculated as 121+22+5.12
I tried to put 2 decimals in each value, but I couldn't. I tried Format([..], "Fixed") but it concatenates the values, it doesn't make a sum
What can I do?
Thanks