MS Access
Explanation…
I have a filed of data formatted as number, I need it as number coze it has
to add up on some other reports and forms that I have (if not formatted as
number then formulas will not work). My only question is, I need numbers
entered in this filed to be displayed the way I enter them.
i.e: if 2.5 then show 2.5 not 2
if 2.30 the show 2.30 not 2.3 nor 2
if 10 then show 10 (which is good in this case)
if 100.25 then 100.25 not 100 nor 100.2
basically, I need them to be displayed exactly the way I enter them.
I have searched and find something similar but not anything that could sort
this problem. I’ve also manipulated with decimal places etc… they failed, too.
to add up on some other reports and forms that I have (if not formatted as
number then formulas will not work). My only question is, I need numbers
entered in this filed to be displayed the way I enter them.
i.e: if 2.5 then show 2.5 not 2
if 2.30 the show 2.30 not 2.3 nor 2
if 10 then show 10 (which is good in this case)
if 100.25 then 100.25 not 100 nor 100.2
basically, I need them to be displayed exactly the way I enter them.
I have searched and find something similar but not anything that could sort
this problem. I’ve also manipulated with decimal places etc… they failed, too.