none
Populating Data into Access Database, based on data in a different field RRS feed

  • Question

  • Hello everyone,

    I am working on an access database that needs to be updated with data to meet expectations for an upcoming audit. The database has data in fields, such as vendor information, invoices, category, etc.

    I have created a new column in the database called "Owner." It is required that I assign an owner, based on the category or check description, and there are 16,000+ rows in this database that need an owner assigned. I'm sure there is a query or something I can use to programmatically assign an owner based on information, instead of having to manually modify 16,000+ rows of data manually. Can anyone provide a clear solution?

    Thank you.

    Wednesday, October 5, 2016 1:30 PM

Answers

  • Hi bhbscfbguy,

    According to your description, you could use update queries in Access databases to add, change, or delete the information in an existing record, I have made a sample to let you refer to:




    The result:

    For more information, please refer to Create and run an update query

    Thanks for your understanding.

    • Proposed as answer by David_JunFeng Friday, October 14, 2016 9:39 AM
    • Marked as answer by David_JunFeng Monday, October 17, 2016 2:36 PM
    Thursday, October 6, 2016 6:22 AM

All replies

  • First develop a regular Select Query of the appropriate tables, that has a new calculated field 'Owner'.  You don't explain the logic in determining the Owner so we'll presume you have a handle on that.

    When you run this query - that Owner field should be populated correctly for all 16k rows.  That is the first step.

    Then you make an Update query.  While some will suggest possibly modifying the Select query to an Update query I tend to think it is safer and easier to create a new query.  You begin with this new query as the record source and set it up to update your table.

    Wednesday, October 5, 2016 1:48 PM
  • Hi bhbscfbguy,

    According to your description, you could use update queries in Access databases to add, change, or delete the information in an existing record, I have made a sample to let you refer to:




    The result:

    For more information, please refer to Create and run an update query

    Thanks for your understanding.

    • Proposed as answer by David_JunFeng Friday, October 14, 2016 9:39 AM
    • Marked as answer by David_JunFeng Monday, October 17, 2016 2:36 PM
    Thursday, October 6, 2016 6:22 AM