Hello all,
I am having some issues with viewing decimal zeros in a report. since Access 2003 does not hold an ending zero in the number field (i.e. 1.10 stores as 1.1) I would like to have a report insert the ending zero so the format reads correctly . However I do not want whole integers to display any decimals at all.

I would like the report to read

1
2
3


4
4.01
4.02
....
4.10
5
5.01
6
7
etc

I can only get the format to read
1
2
3
4.01
4.02
....
4.1
5
5.01
or
1.00
2.00
3.00
4.01
...
4.10

is there a format code I can insert in the report or query design to choose when to correctly format whole integers and decimals.
Thanks