Results 1 to 7 of 7
  1. #1
    vivah is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    18

    update query - to replace "name" with paralell info in the next column which is Field

    hi friends, pls help.
    I am trying to replace the "Name" value with corresponding\paralell value in the next coloum.



    how to write this udpaet query?
    pics attached.

    basically all those "name"s should be removed, and instead paralell value from the next colum should but put in. how to write the update query pls?

    Vivah

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I have checked your screen shots. You want to basically replace the first field data with the data in the parallel feild.

    use this sql to create your update query:

    UPDATE TableName SET TableName.FieldName you want to update = [TableName].[Parallel FieldName]; is the syntax
    UPDATE sfw Inventory SET sfw.Softwarename = [sfw Inventory].[Version];(This is what you need to type check the field names before you proceed)

    if you want to create the query using the query wizard

    Create an update query
    In the First Column Field Select the Field you want to update
    In UpdateTo type the following [swf Inventory].[version]

    run the query


    please mark this thread to be solved if you are able to solve your problem.

  3. #3
    vivah is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    18

    Smile Thanks much, it worked.

    Thanks much, it worked.

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I just can't find the database try uploading it again

  5. #5
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    I am extremely sorry but now it seems that you are taking about something that I had uploaded. As far as I remember I had not uploaded anything with this post. The Last mdb upload that I had made was in Reply to a thread titled ListBoxes by WillTC thats it. I am sorry I just can't get you. Please write to me at silverback_bats@yahoo.co.in in detail perhaps I will be able to understand better.

  6. #6
    vivah is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    18
    hello,
    I need help merging two fields into 3rd empty field. , how to ?Click image for larger version. 

Name:	selected sfw pull.png 
Views:	3 
Size:	14.1 KB 
ID:	8548

    Thanks,
    Vivah

  7. #7
    vivah is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    18

    Solved, thanks

    solved, thanks
    Last edited by pbaldy; 07-25-2012 at 07:34 AM. Reason: Deleted spam in quote

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

Similar Threads

  1. Populating a "Text" field in a Report
    By two_smooth in forum Reports
    Replies: 20
    Last Post: 02-19-2010, 11:25 AM
  2. replace a empty field with the word "none" how??
    By techexpressinc in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 11:02 AM
  3. Creating "Edit Record" link in table column
    By joshearl in forum Forms
    Replies: 1
    Last Post: 12-25-2009, 11:17 AM
  4. Error message and How do I find the "value Field" ?
    By createdwithfire in forum Forms
    Replies: 1
    Last Post: 11-05-2009, 12:26 PM
  5. aSTR = Dir("C:\*.*") >> "Type Mismatch"
    By JGrant in forum Programming
    Replies: 1
    Last Post: 03-28-2009, 05:17 AM

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