Results 1 to 2 of 2
  1. #1
    cd3atm is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Dec 2010
    Posts
    1

    How to make an Update Query

    Hello I'm trying to create an update query. I have an inventory table that contains the type of inventory. One of my inventory types is "Copy Machine". I want to create an update query that changes "Copy Machine" to "Copier", but I am really struggling. Any advice is appreciated.

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    you should get a textbook of Access or read an online book about update query.

    this is the example:
    update yourtable set inventoryType="Copier" where inventoryType="Copy Machine"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  2. How to make update to database???
    By skocev in forum Access
    Replies: 2
    Last Post: 03-31-2010, 02:47 PM
  3. Replies: 6
    Last Post: 03-27-2010, 11:18 AM
  4. How to make a query Crash?
    By techexpressinc in forum Queries
    Replies: 5
    Last Post: 03-09-2010, 01:05 PM
  5. warning to make update note
    By ga3la in forum Access
    Replies: 1
    Last Post: 01-30-2010, 09:51 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums