Creating A TABLE via sql

Results 1 to 2 of 2

Thread: Creating A TABLE via sql

  1. #1
    Join Date
    Dec 1969

    Default Creating A TABLE via sql

    I want this to eventually run via an ASP script. I am trying to create a table via sql but i am not sure how to assign the Autonumber and Yes/No fields in the sql, as it always chucks an error.<BR><BR>My current sql is below<BR><BR>CREATE TABLE jan2003invoices (ID AutoNumber, pid Text, accref Text,quantity Number,net Currency,inv Number,paid Yes/No);<BR><BR>please can anyone help i am using MS Access 97<BR><BR>Waseem

  2. #2
    Join Date
    Dec 1969

    Default RE: Creating A TABLE via sql

    Well I would question why you need to do this?<BR><BR>You appear to want to create a table to store invoices in jan2003, so presume ditto feb, mar,...<BR><BR>Why not have one invoices table with a field to indicate the time period then your problem goes away and this structure is much more efficient anyway.<BR><BR>Cheers<BR>Tim

Posting Permissions

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