Question: when i enter the folowing code i get syntax error in field destination CREATE TABLE TRIP ( TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50),

when i enter the folowing code i get syntax error in field destination

CREATE TABLE TRIP (

TRIP_ID DECIMAL(3,0) PRIMARY KEY,

TRIP_NAME CHAR(75),

START_LOCATION CHAR(50),

STATE CHAR(2),

DISTANCE DECIMAL(4,2),

MAX_GRP_SIZE DECIMAL(4,2),

TYPE CHAR(20),

SEASON CHAR(20)

);

what can i do to get this code to execute and create my table

using sql in microsoft access

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!