Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: Help with a update query

    Hi, I have a database with about 2000 records. I have several records that I would like to update the photo attachment that match certain clients. Is there an easy way to accomplish this?

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Probably. Without knowing your table structure, current data, available new data and desired output, it's difficult to say more!
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  3. #3
    Join Date
    Mar 2013
    Posts
    2
    Hi, I have a basic table with names address, and so forth with a field to hold attachments. I would like to make a query to select clients with the same name and update the attachment field with the same photo. I have set up a query that selects just the clients I want in the clientname field but don't know how to just update the attachment field with the same photo in all of them. I don't know if this helps or not.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Code:
    update mytable
    set mypicture = 'my/path/to/the/picture.jpg'
    where thesurname = 'buckeyefan'
    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
  •