Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    5

    Unanswered: inserting into many rows with one query

    i have a table with about 40 columns in access 97( terrible i know, but
    its not mine and im not allowed normalize or change it) . i have added
    a column , which is a number , called year. it will contain 1997,
    1998, etc. there are about 1600 rows in the table. is there anything
    like a correlated sub query that will allow me to insert this into the
    year column of each row?? i dont want to do it one row at a time

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Use an Update Query

Posting Permissions

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