Results 1 to 2 of 2
  1. #1
    civileng is offline Novice
    Windows 8 Access 2013
    Join Date
    Apr 2013
    Posts
    1

    if text contains then

    I have a querie that contains column1 with text(description of incident maybe weather info). I would like to create new column which would search throug column1 and then insert certain word into this new column if searh is sucessful. For example if column 1 contains word snow then snow if colum1 contains word foggy then fog.

    colum1................ ..........newcolumn
    crash reason snow... ......snow


    slow traffic, foggy ..........fog

    What is the simplest way to solve this problem?

  2. #2
    Rawb is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2009
    Location
    Somewhere
    Posts
    875
    The best way would probably be with a custom VBA function that takes colum1 as an argument and returns "snow", "fog", etc. Then you can just call that function from inside your Query.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-07-2013, 09:53 PM
  2. Replies: 1
    Last Post: 05-24-2012, 04:59 AM
  3. Replies: 2
    Last Post: 03-01-2012, 12:21 PM
  4. Replies: 15
    Last Post: 04-01-2011, 11:41 AM
  5. Replies: 1
    Last Post: 11-05-2010, 04:31 PM

Tags for this Thread

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