Formatting currency with the cents but without the decimal point
in [Reports]
|
Prev: dynamic adaptive / variable report field format
Next: Multiple Reports – Same Query – Underlying Data Changes Freque
From: tgavin on 12 Jan 2010 17:36 I have a client who needs to export check information in a text format. The bank is requiring that all fields take x number of characters, which I have been able to do except that the check amount needs to read 10 digits without the decimal place. ie: $247.84 becomes 0000024784. I can get it to 00000247.84 with the function Format([CkAmount],00000000.00) but the minute I take out the decimal, I get a decimal, I get 0000000247. I should also mention that this is an Access 97 db that has to be totally redone at some point in a later version. It won't convert to any higher a version because there is a lot of code in it that goes back to either Access2 or Access 95. Thanks Terri
From: fredg on 12 Jan 2010 19:45
On Tue, 12 Jan 2010 14:36:01 -0800, tgavin wrote: > I have a client who needs to export check information in a text format. The > bank is requiring that all fields take x number of characters, which I have > been able to do except that the check amount needs to read 10 digits without > the decimal place. ie: $247.84 becomes 0000024784. I can get it to > 00000247.84 with the function Format([CkAmount],00000000.00) but the minute I > take out the decimal, I get a decimal, I get 0000000247. > > I should also mention that this is an Access 97 db that has to be totally > redone at some point in a later version. It won't convert to any higher a > version because there is a lot of code in it that goes back to either Access2 > or Access 95. > > Thanks > Terri Multiply the [CkAmount] by 100. Also, the format must be a string, as below. From the Access Debug window: ?Format(284.84 * 100,"0000000000") 0000028484 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |