How to set Format and decimal places using ALTER TABLE

Can anyone help with the ALTER TABLE statement to change a fieldsize Long Integer to Fixed Format 2 decimal places.

Thanks in advance.
Clive BeatonAccess DeveloperAsked:
Who is Participating?
PatHartmanConnect With a Mentor 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 DeveloperAuthor Commented:
Thanks very much.  I never did understand the difference.  Now I do.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.