How to set Format and decimal places using ALTER TABLE

Clive Beaton
Clive Beaton used Ask the Experts™
on
Can anyone help with the ALTER TABLE statement to change a fieldsize Long Integer to Fixed Format 2 decimal places.

Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
That is not possible.  Integers are whole numbers.  If you want decimal positions, you need to use a data type that supports them.  The most user-friendly choice is Currency which works as long as you only need four decimal places.  Don't confuse the Currency data type with the Currency format.  The Currency data type can be formatted however you want.

Also, formatting doesn't affect how data is stored.  It only affects how data is displayed.  Formatting is for humans.
Clive BeatonAccess Developer

Author

Commented:
Thanks very much.  I never did understand the difference.  Now I do.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial