Results 1 to 5 of 5
  1. #1
    tonyhansson is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34

    Update Query

    Hi



    I have an update Query, opdating one table from another table (Working Fine)


    Some days there no records to update (only add), and the Query is not working, because there is no records to find.


    How can I Work around this problem?

    Regards

    Tony

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    What exactly is the problem? If there is no data to update, why run the query? How are records added? Review https://stackoverflow.com/questions/...14004#37014004
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Join Date
    Apr 2017
    Posts
    1,673
    UPDATE, INSERT (and DELETE) queries are different animals at all. There is no way you can do all those actions with single query.

    So you need an INSERT query to add new records, an UPDATE query to update existing records, and probably a DELETE query to delete some records on certain criterions too. And some procedure, which everyday runs all those queries, unless you prefer to do this manually.

  4. #4
    tonyhansson is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Aug 2020
    Location
    Copenhagen, Denmark
    Posts
    34
    Okay I will make 3 query instead of 2.

    Tks

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Did you review link referenced in post 2?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-03-2017, 04:58 AM
  2. Replies: 1
    Last Post: 10-27-2016, 12:14 PM
  3. Query Update/Select Query (Wont Update)
    By NickWren in forum Access
    Replies: 1
    Last Post: 03-30-2016, 10:41 AM
  4. Replies: 7
    Last Post: 08-26-2013, 06:05 AM
  5. Replies: 2
    Last Post: 08-30-2012, 07:59 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