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.
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
Fredg, Thank you, so simple a solution I completely over looked it. Thanks, again! "fredg" <fgutkind@example.invalid> wrote in message news:1w6w8a6cm0uup$.19e147eobh9m8.dlg@40tude.net... > 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 >
