Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    37

    Question Unanswered: Replacing Data in an Access Table

    Hello -

    I have a main table in Access which includes two fields called 'Order #' and 'Trade #', amongst many others. For the last couple of months, Order # has been populated with zeros by mistake.

    I have created a temporary table which, for the records affected, maps the trade # to the correct Order #.

    What's the easiest way to replace these in the master table???


    Example:

    Master Table

    Trade # Order #
    1 0
    2 0
    3 0


    Temp Table

    Trade # Order #
    1 6
    2 7
    3 7


    Corrected Master Table should look like temp table.

    Thanks!

  2. #2
    Join Date
    Feb 2004
    Posts
    214

    ...

    Join the two tables in a query by Trade #

    Then make an update query to the main table

    The Update to field will look something like this.

    Update To: [Your Temp Table].[Order#]

    *Always make a backup of your main table before running any type of action query in case something doesn't work properly.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

Posting Permissions

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