Standard format. How?, Excel, Word, Access, Powerpoint, Office, Publisher, Visio, Outlook" /> Standard format. How? Setting Up & Running Reports" />
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format problem : "Text" & Number; Number -> Standard format. How?
Hi,
Access Version 97 eng. under WinNT4 I have a report which will be printed and send to 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? -- TIA Bernd |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sending email in HTML format - problems with Text Format | Krish | General Discussion | 0 | July 14th, 2004 08:40 AM |
Enter Numbers as Text in Social Security Number Format | Frank Kabel | Worksheet Functions | 0 | March 18th, 2004 09:17 PM |
Format Social Security Number as Text | Robert | Worksheet Functions | 2 | March 16th, 2004 05:28 PM |
Excel wrap text problem | Ellen Kemper | Setting up and Configuration | 4 | December 2nd, 2003 03:24 PM |
Format the content of a cell as Text | CLR | Worksheet Functions | 1 | September 30th, 2003 01:19 PM |