NDVI result seems wrong
The error was in the formula. I looked at the values in the raster and they where being rounded down to the nearest integer in the output. The following formula fixed it.
(Float([NIR]) - Float([R])) / (Float([NIR]) + Float([R]))
or
are you using the float button on the right hand side of the calculator?
If it's not showing there is a small >> at the bottom right.