Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add to data in a particular field (Access 97)

    I would like to update all of the records in one field of a table. Actually, I would like to add 2004 to the existing data in the field. Is there any way to use an update query to do this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Add to data in a particular field (Access 97)

    Yes, you can use an update query. Add only the field you want to update to the query grid.

    I'm not sure what exactly you want.
    If you want to set the value of the field to 2004 in all records, enter 2004 in the 'Update to' row.
    If you want to add (numerically) 2004 to the value of the field, enter [FieldName]+2004 in the 'Update to' row, where FieldName is the name of the field.
    If you want to append 2004 (as a string) to the value of the field, enter [FieldName] & "2004" in the 'Update to' row, where FieldName is the name of the field.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add to data in a particular field (Access 97)

    Thanks, I actually wanted to append 2004 to the data already in the field.

    Works great!!

Posting Permissions

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