Results 1 to 11 of 11

Thread: Access Help

  1. #1
    Join Date
    Jun 2007
    Posts
    5

    Unanswered: Access Help

    hi im using Microsoft Access, and with the following statement. im just wondering where im supposed to put it

    CREATE TABLE supplier
    ( supplier_id numeric(10) not null,
    supplier_name varchar2(50) not null,
    contact_name varchar2(50)
    )


    its used to create a table and im not sure where to place the statement
    if someone could please help. it wuld be greatly appreciated
    thankyou daniel.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Create a new query in SQL view and paste that into the view and run it
    Queries > New Query In Design View > Switch to SQL view
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2007
    Posts
    5
    um thanks for the reply, one more question...
    how do i run it... i briefly remember having to create a macro or somethin ?
    can someone run me thru running the query because im having problems doin it

  4. #4
    Join Date
    Jun 2007
    Posts
    5
    there is also errors in the sql to create a table

    can anyone supply me with an example of a CREATE TABLE statement that i will be able to modify and enter my own data
    thank you

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Just because I'm such a fiendishly evil sort of human being, I'm moving this thread from Other Forum to the Microsoft Access Forum... I suspect that it will get a lot more attention there!

    -PatP

  6. #6
    Join Date
    Aug 2006
    Posts
    559
    Quote Originally Posted by lostman
    um thanks for the reply, one more question...
    how do i run it... i briefly remember having to create a macro or somethin ?
    can someone run me thru running the query because im having problems doin it

    To run the query in MS Access, just click the "!" at the top, that'll run the query so you can test to see if it works.

    From what I'm seeing, you're trying to generate a table from a query? Correct?

  7. #7
    Join Date
    Jun 2007
    Posts
    5
    thanks mate

  8. #8
    Join Date
    Jun 2007
    Posts
    5
    yeh im trying to create a table from a query

  9. #9
    Join Date
    Aug 2006
    Posts
    559
    You can try these steps if you're trying to make a table from a query (if you have the tables created which you are querying):

    1. Open the db, select query
    2. click "new" and "design view"
    3. create the query with the tables or queries you want within the new table and select "make table" from the query menu.
    4. Put the name you want your table to have in the "Table Name" box
    5. select current database or other database to show where the table created you want stored.
    6. drang your fields from the field list to the grid.
    7. input your criteria
    8. preview table by switching to "datasheet view"
    9. go back to the query in design view, click run query (!) on the toolbar.

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by lostman
    there is also errors in the sql to create a table

    can anyone supply me with an example of a CREATE TABLE statement that i will be able to modify and enter my own data
    thank you
    http://w3schools.com/sql/sql_create.asp
    George
    Home | Blog

  11. #11
    Join Date
    Jan 2005
    Posts
    31
    JET SQL DDL has a few differences (mostly limitations) over standard SQL DDL.

    Even though this is an Access 2007 reference, it should be of assistance because JET SQL DDL has not changed significantly since Access 2000 (as far as I know).

    MSDN: Data Definition Language

    EDIT------------

    Oh, and you'll need to know MS Access datatypes.

    MSDN: Equivalent ANSI SQL Data Types

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •