Adding or delete decimal points in column of currency figures

[Guest]

If I have a column of dollar figures (no dollar sign) with the decimal point
intact, is it possible to delete the decimal point so that only the numbers
remain?

 

[Rick B]

You can display a number in pretty much any format you want. This does not
affect the underlying data in your table though.

In your query, reports, or forms, use the FORMAT command to establish how
your data displays. The help files can be used if you need more help.

 

[Guest]

You can use

=Round([FieldName])
will round the number 2.2 to 2 / 2.7 to 3

Or
Int([FieldName])
Will round 2.2 and 2.7 to 2

 

[John Vinson]

If I have a column of dollar figures (no dollar sign) with the decimal point
intact, is it possible to delete the decimal point so that only the numbers
remain?

To permanently truncate the number - i.e. to convet 8.99 to 8 (stored
internally as 8.0000), you can run an Update query updating the field
to Fix([fieldname]). You can round to the nearest integer (nearest
even integer for .5) using Round([fieldname], 0).

You can use the same expression in a Select Query to leave the table
alone but get an even-dollar figure for calculations or the like.

John W. Vinson[MVP]

 

[Joseph Meehan]

If I have a column of dollar figures (no dollar sign) with the
decimal point intact, is it possible to delete the decimal point so
that only the numbers remain?

Well column is a spreadsheet term. We talk about fields here.

You say you have dollar figures. Do you mean it is a currency type
field? Could it be a text or a some other form of number field?

 

[Guest]

What I am trying to do is change the number like this: I have 23.84 and I
want it to be 2384 or the reverse: from 2384 to 23.84. All of the ways I
have tried to move the decimal point either adds or deletes zeros or rounds
the number off.

 

[John Vinson]

What I am trying to do is change the number like this: I have 23.84 and I
want it to be 2384 or the reverse: from 2384 to 23.84. All of the ways I
have tried to move the decimal point either adds or deletes zeros or rounds
the number off.

Multiply or divide by 100.

John W. Vinson[MVP]

 

[Joseph Meehan]

What I am trying to do is change the number like this: I have 23.84
and I want it to be 2384 or the reverse: from 2384 to 23.84. All of
the ways I have tried to move the decimal point either adds or
deletes zeros or rounds the number off.

The answer to your question does depend on what kind of field that
"number" is in.

When I see 23.84 in Access I know it may be a text field and I then
would need to just search for and remove all periods. On the other hand if
is was a number field I could multiply it by 100. Of course that would
change the number to something other than 23.84 currency fields have some
other quirks.