+ Reply to Thread
Results 1 to 2 of 2

Find and Replace Multiple

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    ND
    MS-Off Ver
    2010
    Posts
    1

    Find and Replace Multiple

    I'm VERY new to access and am trying to build a database. I think I have the basics down, but now I am trying to do a query or maybe macro to find a replace multiple sets of data:

    for every place under my column "Item Type" where the number equals one of the following: 911000002100, 911000002101, 911000002102, 911000002103, 911000002110 - I need the numbers to be changed to SUB.

    Every place that the numbers in the "Item Type" column equal: 911000002200, 911000002201, 911000002202, 911000002203, 911000002210 - I need the numbers to be changed to UNSUB.

    Everyplace that the numbers in the Item Type Column equal: 911000002500, 911000002501, 911000002502, 911000002503, 911000002510 - I need the numbers to be changed to PLN.

    Everyplace that the numbers in the item type column equal: 901000001100 - I need the number to change to PE.

    Every time the number in the Item Type Column equals: 911000002300 I need the number to change to PERK. Every time the number in that column is: 92000001000 - I need the number to change to WSY.

    Everytime the number in that column is: 901000001110 - I need the number to change to SGE.


    All these numbers are in the same column. When looking at access, it seems like I will need to write something in Visual Basic, but I don't know anything about visual basic. Does anyone have some suggestions about what I will need to do?

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Find and Replace Multiple

    This can be done with a series of update queries. Here is a link on how to do that

    http://www.databasedev.co.uk/update_query.html

    Post back with specific question once you begin/attempt this.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1