Results 1 to 2 of 2
  1. #1
    xinshijie is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2019
    Posts
    1

    Select Query to Correlate Data

    Hey everyone,

    I am currently working with a large data set and am trying to correlate data. In this instance the data is all in the same table. I'd like to query the data for partial matching data. The problem I am having is how the data is formatted in the table. I am querying on IP address. The addresses areIn a table formatted below, how would I write a query to return all results that have matching data? Would it be possible to us a wild card and catch a larger subnet (ie 192.168*)?



    Some cells are delimited by semi-colons and contain multiple addresses like this:
    123.172.108.71; 152.135.10.142; 111.109.9.134; 34.14.108.76; 161.13.108.77
    Some cells only contain one address

    10.0.3.1


    Thanks for any suggestions!

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    think you will need a vba function to use in a query so the query could be quite slow for large datasets

    would be significantly faster if you could normalise your data to one IP per row

    for a vba function, see post #30 of this link https://www.accessforums.net/showthr...075#post443075 which contains a small db looking for words in a phrase. Uou would need to substitute the space of a semi colon and probably remove the last semi colon

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

Similar Threads

  1. Replies: 1
    Last Post: 05-02-2014, 09:29 AM
  2. Correlate dates between two tables.
    By michaelwh1 in forum Access
    Replies: 6
    Last Post: 04-15-2014, 11:01 AM
  3. Select Query is double counting data
    By becka11 in forum Queries
    Replies: 10
    Last Post: 04-10-2013, 03:45 PM
  4. Replies: 7
    Last Post: 12-30-2012, 03:59 AM
  5. Replies: 2
    Last Post: 01-31-2011, 08:31 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