<div>
Thanks very much. &nbsp;I never did understand the difference. &nbsp;Now I do.
</div>


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

<div>
<div class="content wysiwyg-content">
Can anyone help with the ALTER TABLE statement to change a fieldsize Long Integer to Fixed Format 2 decimal places.<br />
<br />
Thanks in advance.
</div>
</div>


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

How to set Format and decimal places using ALTER TABLE

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.