Following a format to text w/o rounding off a number

  • Thread starter Thread starter Arvin Villodres
  • Start date Start date
A

Arvin Villodres

Hi there.
The amount that is reflected in my table is 1,745.63 as
one of its entries.
However, if I put it in a query and is formatted this way:

Format([AMOUNT], "000000000000000") (15 digits)

the output is 00000000001746 .

How can I make my output appear with its decimal digit and
not being
rounded off but is still padded with zeroes?

Looking this way

000000000174563

Thank you very much for your time and help.
 
In the query right click on the field, click properties.
Where it says Format type 000000000000000.00 and where it
says Decimal Places type 2. I tested this and it worked
great. I'm not sure if you left out the decimal in your
example below but if you did NOT and you want the field to
have no decimal you should still do the above except
Decimal Place will be 0 and you will have to put an
expersion in the Query Field. OutPutName:Fieldname*.02

Marty
 
I've just done it and still I get a rounded off figure.

Here's what it looked like.

0000001542.63

I need to have an output that looks exactly like this

000000154263

Do you still have any ideas? Thanks for the reply.
-----Original Message-----
In the query right click on the field, click properties.
Where it says Format type 000000000000000.00 and where it
says Decimal Places type 2. I tested this and it worked
great. I'm not sure if you left out the decimal in your
example below but if you did NOT and you want the field to
have no decimal you should still do the above except
Decimal Place will be 0 and you will have to put an
expersion in the Query Field. OutPutName:Fieldname*.02

Marty

-----Original Message-----
Hi there.
The amount that is reflected in my table is 1,745.63 as
one of its entries.
However, if I put it in a query and is formatted this way:

Format([AMOUNT], "000000000000000") (15 digits)

the output is 00000000001746 .

How can I make my output appear with its decimal digit and
not being
rounded off but is still padded with zeroes?

Looking this way

000000000174563

Thank you very much for your time and help.
.
Click to expand...
.
Click to expand...
 
Multiply by 100 and then format

Format([AMOUNT]*100, "000000000000000") (15 digits)



Arvin said:
I've just done it and still I get a rounded off figure.

Here's what it looked like.

0000001542.63

I need to have an output that looks exactly like this

000000154263

Do you still have any ideas? Thanks for the reply.
-----Original Message-----
In the query right click on the field, click properties.
Where it says Format type 000000000000000.00 and where it
says Decimal Places type 2. I tested this and it worked
great. I'm not sure if you left out the decimal in your
example below but if you did NOT and you want the field to
have no decimal you should still do the above except
Decimal Place will be 0 and you will have to put an
expersion in the Query Field. OutPutName:Fieldname*.02

Marty

-----Original Message-----
Hi there.
The amount that is reflected in my table is 1,745.63 as
one of its entries.
However, if I put it in a query and is formatted this way:

Format([AMOUNT], "000000000000000") (15 digits)

the output is 00000000001746 .

How can I make my output appear with its decimal digit and
not being
rounded off but is still padded with zeroes?

Looking this way

000000000174563

Thank you very much for your time and help.
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top