Question: Im using sql in Microsoft Access CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20),

Im using sql in Microsoft Access

CREATE TABLE TRIP (TRIP_ID DECIMAL(3,0) PRIMARY KEY, TRIP_NAME CHAR(75), START_LOCATION CHAR(50), STATE CHAR(2), DISTANCE DECIMAL(4,0), MAX_GRP_SIZE DECIMAL(4,0), TYPE CHAR(20), SEASON CHAR(20)); I keep getting syntax error and it highlights decimal what am I doing wrong

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!

===== Database: We will use the San Francisco Bike share database. Only part of the data is included with this homework. Database Schema: CREATE TABLE station ( // bike stations id INTEGER PRIMARY...

HOW CAN I CHANGE THE TABLE NAMES TNANKS O X @ DOO SQLAdditions 1 > | Jump to 46 MySQL Workbench f u nconnected x Local instance MySQL57 (col. x Local instance MySQL57 (colonial.x File Edit View Query...

Describing Data Once we have collected data from surveys or experiments, we need to summarize and present the data in a way that will be meaningful to the reader. We will begin with graphical...

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

You are designing a new syntax for a programming language like Java, with the intention of making it more approachable to students by using English words instead of punctuation symbols. (a) How does...

T Problem: This program will read in a large US Coast Guard database of ship position information from the Automatic Identification System (AIS)1. The student provided functions will: Prompt the user...

Develop a high-quality, object-oriented C++ program that performs a simulation using a heap implementation of a priority queue. A simulation creates a model of a real-world situation, allowing us to...

1411116 - Programming I Assignment #3 Due Date: November 30, 2016 Submission Instructions: Submit your assignment on the blackboard link, corresponding to your Section: Please follow the following...

Hello, I am having trouble with this hw in C. Below, Ive listed the directions, codes provided, which include the test cases along with how to carry out the test cases, thank you. A sample output...

4.2. Calculations Calculate the sieve analysis as shown in the following example: 4.2.1. Wash Sieving Dry Weight of Sample 1000.0 g Dry Weight After Washing 950.0 g Weight of Material Washed Through...

A signalized intersection approach with a demand volume of 800 veh/h operates at an effective ratio of 1.05 for a peak 30-minute period each evening. If the approach has a g/C ratio of 0.60 and the...

Problem 1 0 - 2 5 Calculating a Bid Price [ LO 3 ] Consider a project to supply 1 0 0 million postage stamps per year to the U . S . Postal Service for the next five years. You have an idle parcel of...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Describe a persuasive message.

Identify and use the five steps for conducting research.

List the goals of a persuasive message.