sql error, can you please tell me what I am doing wrong

Question

can you explain what I did wrong

I Am trying to make an sql table in Microsoft Access but I am getting a syntax error for create table with the following code:

CREATE TABLE SALES_REP (

REP_NUM CHAR( 2 ) PRIMARY KEY,

LAST_NAME VARCHAR( 15 ),

STREET CHAR( 15 ),

CITY CHAR( 15 ),

STATE CHAR( 2 ),

POSTAL_CODE CHAR( 5 ),

COMMISION NUMERIC( 7, 2 ),

RATE NUMERIC( 3, 2 )  );

Answer 1

I don't think Access recognizes the CHAR type. Try changing them to VARCHAR.

Answer 2

it worked for me (screen shot to prove it if you want)

BUT I am using sqlite

STATE may be a reserved word.

Try using sales-rep prefix to mangle your column names:

salesRepLastName,

salesRepFirstName,

salesRepSTATE

salesRepCITY,

etc

I only use VARCHAR, DECIMAL, and INTEGER

otherwise, your syntax looks good, no missing commas, and

balanced parenthesis