Problem with format in a report

[BerHav]

Hi,

I use Access 97 eng. under WinNT4.

I have a report which will be printed and send to e.g. newspapers and have a
problem with a field where in some cases a text needs to be added to a
number. The number (EUR amount) should be shown in Standard format with 2
decimal places, e.g. 1.234,45 (Thousands Point, Decimal Comma!!)

I tried to add the Format(Number, "##.##0,00") in a query on which the
report is based on and in the Report itself but get either only e.g. 60 and
10,9 or an error from the formula - asking me when running the report for a
value for Format.

Field Type of Number is double - I don't want to change it to currency as I
don't want to have the currency symbol in the field.

Last but not least the used formula in the report:
=IIf([Ratio]>1;IIf(Int([Ratio])<>[Ratio];"In Addition " &
[Amountrounded];[Amountrounded]);[Amountrounded])

(Semicolons in the formula above are due to regional settings = German
Standard)

Any Suggestions how to solve this?

 

[Jeff Boyce]

Is there a chance you could set the type to Currency but display using a
format of "Fixed"?

 

[Wayne Morgan]

It may not understand the format you've entered, but if it's asking for a
value for Format, then it sounds is if it didn't recognize the function at
all. This is usually a References error. See this link for instructions on
how to fix that.

http://members.iinet.net.au/~allenbrowne/ser-38.html