Simple query crashes /Need help with sql

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 simple tables. One has IpNumbers in them that I have collected.
The other table has ranges linked with country codes.

I need a query that will return the IPNumbers linked with the country codes.

I have this query and it does what I want it to, but it crashes every
doggone time. My friend said it was due to an innerjoin? I don't know what
that is.

Also, the data types are all double because they are long numbers.

Please help! I've worked my tail off to get to this last point but can't
finish because I can't run these queries.
 
I have 2 simple tables. One has IpNumbers in them that I have collected.
The other table has ranges linked with country codes.

I need a query that will return the IPNumbers linked with the country codes.

I have this query and it does what I want it to, but it crashes every
doggone time. My friend said it was due to an innerjoin? I don't know what
that is.

Also, the data types are all double because they are long numbers.

Please help! I've worked my tail off to get to this last point but can't
finish because I can't run these queries.
Click to expand...

Double would NOT be appropriate for IP addresses! You'll have all
sorts of trouble with roundoff error. I'd use four Integer (or Byte)
fields as a joint Primary Key, and use all four fields in the join.

Could you post the SQL view of the Query? In what way does it "crash"
- does Access bluescreen, or does the query generate an error message,
or what?


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Ah, its not IP numbers as in dotted quad, but the decimal equivilents and its
working ok - I had a friend write a vba routing to loop through and do the
compares and generate tables. Working great now. I don't think you could do
what I was trying to do before becaues there was no real relationship.
 
Back
Top