Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Richmond, VA
    Posts
    12

    Unanswered: Adding lots of values

    I've created a new column in a table with over 5000 records and i'm trying to place the exact same text in each of the blank fields for all the records. How can this be done? It's driving me mad.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Adding lots of values

    Originally posted by Peakuser
    I've created a new column in a table with over 5000 records and i'm trying to place the exact same text in each of the blank fields for all the records. How can this be done? It's driving me mad.
    SQLString="UPDATE MyTableName SET MyNewColumn=SomeNumber;"
    DoCmd.RunSQL SQLString

    Or

    SQLString="UPDATE MyTableName SET MyNewColumn='Some string';"
    DoCmd.RunSQL SQLString

    Or ... Take your pick on the appropriate data type ...

Posting Permissions

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