Results 1 to 2 of 2

Thread: Update Query

  1. #1
    Join Date
    May 2014

    Unanswered: Update Query

    I have a table with 7000 records and I want to update 80 records say Name field with the concatenated name field name now. How can I design that query.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    Use an update query
    limit the rows processed using a where clause

    The query takes the following form:-
    Update mytable set acolumn = avalue where anothercolumn = 23
    Text/string valus to be delimited with a pair of ' or "
    Eg where userid ='JJ2'
    Dates values to be in ISO or US format delimited by #
    Eg where adatecolumn = #2014/12/25#

    But in your post theres a couple of concerning items. Now and Name are reserved words in MS Access /JET. You will probably get away with it but my strong advice is do not use reserved words or symbols for table or column names. It will cause problems at some stage.

    As to how you update rows, well providing you can identify those rows you can
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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