Thread: decimal values for equation in a sql query

SELECT T_vineyardblockdata.cultivars AS cultivars, Count(T_vineyardblockdata.cultivars) AS Total, Q_countTotalsvineyardblock.countblocks AS summation, [Total]*100\[summation] AS Percentage
FROM T_vineyardblockdata, Q_countTotalsvineyardblock
GROUP BY T_vineyardblockdata.cultivars, Q_countTotalsvineyardblock.countblocks;

i have this query. i have tried to set the formats in design view but cannot get the PERCENTAGE column to display decimal values...

Example: Total = 10; summation = 3 then Percentage = 3.33 but with my sql this Percentage = 3

any ideas?

You could use Access's Format function:

SELECT T_vineyardblockdata.cultivars AS cultivars, Count(T_vineyardblockdata.cultivars) AS Total, Q_countTotalsvineyardblock.countblocks AS summation, Format([Total]*100\[summation],"0.00") AS Percentage
FROM T_vineyardblockdata, Q_countTotalsvineyardblock
GROUP BY T_vineyardblockdata.cultivars, Q_countTotalsvineyardblock.countblocks;

Given your formula, I'd expect 333.33. I don't know why this just occured to me, but instead of using "0.00" you could just use "Percentage", I think.

Where are you reviewing your results? If in a table, check that the data type is double instead of integer.