I am building a chart off of a query. In this query I have set the properties for the columns to a FIXED format with a 0 for decimal places. But when I run my report, my datasheet does not show this - it shows all of the decimals. I even went inside the datasheet view and changed my number format to "Number" with 0 decimal places. PLEASE HELP ME. I've been sitting here for days trying to figure this out.

I forgot to add that when I run the report it does show the datasheet without the decimal points - but when I go to print the chart, it asks me for the query again and the decimal points print!

I suspect you'll have to use the Format function in the underlying SQL statement