Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Rows in a Table (2003)

    If, on the startup form of the attached mdb, you select March 1, 2006 as begin date and March 31, 2006 as end date and run the Query113up update query, only the dates already present in the G2Dez table are updated. I thought putting a Right outer join in the query would also tranfer the unmatched rows from the HourToDay table to the G2Dez table but it doesn't. How can I do it?

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

    Re: Updating Rows in a Table (2003)

    An update query, as the name indicates, updates records, i.e. the records must already exist. An update query cannot be used to append new records to a table. You need an append query to do that. So you must create an append query that adds the unmatched rows to G2Dez, and run that as well as the update query.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Rows in a Table (2003)

    Thank you Hans.

Posting Permissions

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