<div>
Its as you say, although you dont need the (percent)<br />
<br />
ALTER TABLE SampleTable ADD COLUMN LO double <br />
<br />
Double either takes no parameters or two parameters<br />
<br />
See here for data types <a href="http://www.w3schools.com/sql/sql_datatypes.asp" rel="ugc">http://www.w3schools.com/sql/sql_datatypes.asp</a>
</div>


Its as you say, although you dont need the (percent)

ALTER TABLE SampleTable ADD COLUMN LO double

Double either takes no parameters or two parameters

See here for data types http://www.w3schools.com/sql/sql_datatypes.asp [http://www.w3schools.com/sql/sql_datatypes.asp]

<div>
But I want it look visually like a percent
</div>


But I want it look visually like a percent

<div>
The formatting of the value is normally done in the user interface not in the actual field in the database, so the value in the database would be 50.0 and you would format it to show 50.0% on screen.<br />
<br />
If you manipulate the field manually using access then you can set the format property to percent, but I dont know if you can do that in SQL.
</div>


The formatting of the value is normally done in the user interface not in the actual field in the database, so the value in the database would be 50.0 and you would format it to show 50.0% on screen.

If you manipulate the field manually using access then you can set the format property to percent, but I dont know if you can do that in SQL.

<div>
is there some other way how to do it with vba ?
</div>


is there some other way how to do it with vba ?

<div>
<div class="content wysiwyg-content">
hi<br />
<br />
i want to add a coulumn to table that the values are format like percents something like this<br />
<br />

<pre><code id="code-10-28139397-1">ALTER TABLE SampleTable 
ADD COLUMN LO double (percent) </code></pre>
</div>
</div>


hi

i want to add a coulumn to table that the values are format like percents something like this

(CODE)

how to add a column to a exist table with a query in access 2013

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.