Display Graph Data Table with Integers rather than decimals

[BarryL]

I have created a query using SQL to calculate the percentage response rate to
a questionnaire e.g. (32.8402366863905). I am using this query to display a
graph with its accompanying data table also displayed in a report. The graph
displays integers on the y axis (eg. 32 but the data table shows the full
decimal number 32.8402366863905). While editing the graph in the report and
I changed the table to display no decimals (right click on datasheet and
select number) and it looks fine when I view it in design view. However,
when I switch to Report View the table reverts back to full decimal number.
How can I get the data table to display an integer rather than a decimal
number with my graph in report view?

 

[BarryL]

I have created a query using SQL to calculate the percentage response rate to
a questionnaire e.g. (32.8402366863905). I am using this query to display a
graph with its accompanying data table also displayed in a report. The graph
displays integers on the y axis (eg. 32 but the data table shows the full
decimal number 32.8402366863905). While editing the graph in the report and
I changed the table to display no decimals (right click on datasheet and
select number) and it looks fine when I view it in design view. However,
when I switch to Report View the table reverts back to full decimal number.
How can I get the data table to display an integer rather than a decimal
number with my graph in report view?

 

[BarryL]

It's ok I got it thanks...

I added the function "CInt" to the SQL expression and got the desired result.

i.e. CInt(VI.Num/Tot.Num*100) AS VI

BarryL