Decimal value problem in access 97 Report

[Sammer]

I have a Integer Value 0.75 in form field and want same value in report, i've set the field property as below at report objects.
Property 0 & Format - General No > Result: 0.8
Property 0 & Format - Fixed > Result: 0.75( this field is coming exactly what I want but changing other field value 9 to 9.00)

Please help me to sort out this issue.

[Stewart Ross]

If use of the general format is rounding your value to 0.8 it suggests you may have defined the value in your table as a single-precision number. I would suggest defining the value as a double-precision number instead.

Regarding the display of 9.00 for the whole number value 9, the textbox format is working correctly. In fixed format with two decimal places all whole number values will indeed show as X.00, where X stands for the whole number being displayed. This is quite normal, and indeed is what is needed for report purposes to line up the decimal point. Otherwise, the values displayed on successive detail lines will look very untidy (e.g.

     9
  0.75
   100
10.251  (and so on) instead of 
 
  9.00
  0.75
100.00
 10.25

-Stewart

[NeoPa]

Other viable options are the Data Type = Currency and Field Size = Decimal. These are there to ensure absolute reliability when dealing with decimal numbers and that no rounding errors occur.

Of course you must ensure not to confuse the Formatting with the holding of the data. Just because a field displays a number one way, doesn't necessarily reflect the precision it's held to.

[Sammer]

Thanks Stewart for your detailed reply.
The value in my table for the field is Number , Double.
This is client approved report where we have to maintain the same standard as earlier (0.75 and others 9 only).

Thanks,

[Stewart Ross]

If you really need to differentiate between different values in your report you can use the Format function in conjunction with an IIF (in-line IF statement) as follows.

First, change the name of the textbox concerned - if it was previously call item_total, say, change it to something different but appropriate like txtItem_total_formatted. The change is to avoid a circular reference occurring in the calculated value for the control source.

Then, change the control source property so instead of the textbox referring directly to the underlying field it is a calculated field, like this:

=IIF([Item_total] < 1, Format([Item_Total], "0.00"), Format([Item_total], "0"))

You will need to use whatever the real name of the field concerned is in place of Item_total listed above. You must make sure you include the equals sign before the IIF statement.

This will format values that are less than 1 with two decimal places, but valus over 1 as whole numbers. You can change this threshold to whatever suits you as necessary.

-Stewart

[Sammer]

I just found that i am getting correct value (0.75) on 2 pcs. our's the domain network. i tried and change all the setting( Regional setting, database field properties, Report properties same as these 2 correctly working Pcs on others Pcs but still getting the same value (0.8). Dont know what and why its happening....please help.

[NeoPa]

@Sammer
Very little of what you say gives us anything to work with. You half say things and expect us to guess what you're talking about. I tried to make sense of it by starting again at the beginning, only to find :

Sammer:
I have a Integer Value 0.75

This is thoroughly nonsensical. Integers have no decimal points.

Also we've seen no code and little helpful design information from you so when you post a few words saying you're still getting the same values on some PCs we're in no better position to help. If you want help then you'll have to start posting more sensible replies.