changing decimal places

[Kate]

I have a subform that performs a calculation as shown:
=IIf(IsNull(Sum([QtyIssued])),0,Sum([QtyIssued]))

The field size of 'QtyIssued' is single, and decimal places is set to
auto.

When I perform the above calculation, if entries in QtyIssued are say
1, 2, and 3, then the calculation will return '6', which is good. But
if the entries in QtyIssued are say 1.2, 4, and 2.1, then the
calculation will return '7.30000000' for example, when I just want it
to display 2 decimal places. If I change the format in the calculation
text box to 'standard' for example, and set the decimal places to 2,
then my first example above would show 6.00 which is not what i want.

Can anyone help with this?

 

[Rick Brandt]

I have a subform that performs a calculation as shown:
=IIf(IsNull(Sum([QtyIssued])),0,Sum([QtyIssued]))

The field size of 'QtyIssued' is single, and decimal places is set to
auto.

When I perform the above calculation, if entries in QtyIssued are say
1, 2, and 3, then the calculation will return '6', which is good. But
if the entries in QtyIssued are say 1.2, 4, and 2.1, then the
calculation will return '7.30000000' for example, when I just want it
to display 2 decimal places. If I change the format in the
calculation text box to 'standard' for example, and set the decimal
places to 2, then my first example above would show 6.00 which is not
what i want.

Can anyone help with this?

I don't think there is a format that will show decimals only when non-zero and
also a fixed number of places.

 

[peregenem]

I don't think there is a format that will show decimals only when non-zero and
also a fixed number of places.

I'm not sure if this is a solution but it sounds like a similar
problem:

http://groups.google.com/group/microsoft.public.access.forms/msg/25ac5801f846ce07