How to set default value in Access

[dododo]

Hi all,

I want to write sql to create table and set default value in access but i got error.

create table tbOne
(
id integer primary key,
gender char(1) default 'F'
)

This is my code and when i run it error: syntax error in create table statement. Please help.

[June7]

Are you using the query designer?

[dododo]

Are you using the query designer?

yes, i am using query desinger in access. pls help me.

[June7]

If you are using the query designer to help build, why would there be a syntax error? Are you typing directly into SQL View?

Review

http://www.w3schools.com/sql/sql_create_table.asp

http://msdn.microsoft.com/en-us/library/ms180897.aspx

The "default 'F'" isn't working. Why do you need to do this as opposed to just creating a table manually? Do you want the ID field to be autonumber?

[dododo]

thanks for your help.