Number not showing up as entered

[icsupt]

I am entering .80. In the form, it's showing as .80. However on the report, it's showing as 1.00.

Format - Fixed
Decimal Place - 2

What am I doing wrong?

HELP!!

Thanks in advance.

 

[BobJacksonNCI]

Your report is using a default setting and Access is automatically rounding.

Fix it by looking into the properties of the report control.



HTH,
Bob

 

[icsupt]

Thanks for quick response.

What should I be looking for in the report properties? I don't see where I would change it.

 

[icsupt]

I see now. I had to change it in the query. In addition, I had the query set to only show "1". Duhhh....

Thanks, you pointed me in the right direction!

 

[BobJacksonNCI]

icsupt,

You helped yourself - I assumed your query was already displaying data as you desired...

Bob