Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Posts
    29

    Unanswered: Linking ip addresses

    I've got a small access db with two tables that are linked from two different sql server databases. i'm trying to compare ip address that are in both tables. the problem is that one of the fields has only the first three octets of the ip address. for example 10.10.134.xx The other table has the full ip address.. Obviously, these are not going to match and no rows will be returned.

    any idea how I can set this up? I would like to group by the partial Ip address and have records that match the first three octets underneath it.

    fisk

  2. #2
    Join Date
    Feb 2006
    Posts
    56
    use a LIKE statement in a query (with a group by) or an instr function.

Posting Permissions

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