Results 1 to 3 of 3
  1. #1
    NikoTheBowHunter is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2017
    Posts
    58

    update multiple records, best method


    Been slowly creating a very simple one table database for me a 2 other coworkers. I quickly noticed I need a way to update multiple records without having to go into each one individually to update the fields that need updating. I have the records set up with a "status field" so when its time to ship a units out, I can pull up the list and based on the status I know which units I can send out. But once we ship out those units, I need to go in and update a couple fields for each of those records. When its a handful of units not a big deal but when we ship out 100+ that a bit much to be updating one by bone. So I turn to you knowledgeable people. How could I do this quickly without having to go into each one. Not sure which direction to go or how to accomplish this. This is my first database ever and I'm not even the computer guy, just a guy they hired to work in inventory and quickly figured out we needed something better than an excel sheet for 3+ people to use.

  2. #2
    NikoTheBowHunter is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2017
    Posts
    58
    think I may have just stumbled across my answer...

    Update data by using a query
    https://support.office.com/en-us/art...5-f6769d2bb717

  3. #3
    NikoTheBowHunter is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2017
    Posts
    58
    yup it did, never mind solved!

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

Similar Threads

  1. Replies: 5
    Last Post: 10-22-2013, 07:37 AM
  2. SQL Update for multiple records
    By robsworld78 in forum Programming
    Replies: 16
    Last Post: 02-26-2012, 09:08 PM
  3. Update Multiple Records
    By anwaar in forum Programming
    Replies: 10
    Last Post: 09-02-2011, 05:16 PM
  4. Update multiple records at once
    By ariklewis in forum Queries
    Replies: 6
    Last Post: 06-13-2011, 02:33 PM
  5. Update dates for multiple (not all) records
    By thekruser in forum Access
    Replies: 2
    Last Post: 08-30-2010, 05:27 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