|
| 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
July 4th, 2008, 06:47 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Formatting a Number in a Query Field
All,
I have a field value that is formatted currency. I need to format the field in a query to have leading zeros and retain the decimal values without the decimal. Example: Field A= 137.19 I need to convert it to 0013719. I've attempted to convert it to a string and format it to"0000000", but that just rounded the number and did not retain the decimal values. I've also tried using the FormatNumber and Val functions without success. Any guidance you could give me would be greatly appreciated. Thanks in advance. 
|
|
#2
July 4th, 2008, 07:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Formatting a Number in a Query Field
On Fri, 4 Jul 2008 10:47:54 -0700, Brad wrote:
All, I have a field value that is formatted currency. I need to format the field in a query to have leading zeros and retain the decimal values without the decimal. Example: Field A= 137.19 I need to convert it to 0013719. I've attempted to convert it to a string and format it to"0000000", but that just rounded the number and did not retain the decimal values. I've also tried using the FormatNumber and Val functions without success. Any guidance you could give me would be greatly appreciated. Thanks in advance. NewColumn:Format([NumberField]*100,"0000000") -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
July 4th, 2008, 07:20 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Formatting a Number in a Query Field
Fredg,
Thank you, so simple a solution I completely over looked it. Thanks, again! "fredg" wrote in message .. . On Fri, 4 Jul 2008 10:47:54 -0700, Brad wrote: All, I have a field value that is formatted currency. I need to format the field in a query to have leading zeros and retain the decimal values without the decimal. Example: Field A= 137.19 I need to convert it to 0013719. I've attempted to convert it to a string and format it to"0000000", but that just rounded the number and did not retain the decimal values. I've also tried using the FormatNumber and Val functions without success. Any guidance you could give me would be greatly appreciated. Thanks in advance. NewColumn:Format([NumberField]*100,"0000000") -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
