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 field as percent
Is there any way to format a number field as percent so
that you do not have to enter the number as .03 to obtain a value of 3%. I want to type in just the number 3 and have it appear as 3% |
#2
|
|||
|
|||
Format field as percent
"Dianne" wrote in
: Is there any way to format a number field as percent so that you do not have to enter the number as .03 to obtain a value of 3%. I want to type in just the number 3 and have it appear as 3% Simplest solution is just to store the 3 and remember to divide by 100 when you do the maths later. Therefore, if the query used to be SELECT FinalCost * (1 + TaxPerCent) AS NetCost FROM etc... you just change it to SELECT FinalCost * (100 + TaxPercent) / 100 AS NetCost FROM etc... If you want to provide a visual clue to the user, try putting a label containing the "%" character just to the right of the text box on the form. Hope that helps Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
cannot change format of a field | DLJ | General Discussion | 5 | August 5th, 2004 09:05 PM |
DATABASE field table format - changes not saved over Citrix | Michael Matuszak | Mailmerge | 7 | June 26th, 2004 03:02 PM |
email format | Lloyd | General Discussion | 1 | June 16th, 2004 03:42 AM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |
Add Space to Field that is consistent format | Beth Dye | Worksheet Functions | 0 | April 30th, 2004 01:16 AM |