Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conversion from Long to Double (Access XP SP2)

    I had the wierdest, and scary experience -- I had two data pulls into Access tables from an MSSQL server via Lotus format, and attempted to join the data pulls to see what matched in both -- which yielded no records. However, outer-joining from one table to the other produced matches, and wierdly, outer-joining from the other direction yielded no matches. I checked the data types, and the identity int in both tables came in as doubles -- so I was attempting to match doubles. I could understand if the conversion from Long to Double didn't come out exactly the same in each table, but -- how would that explain the fact that _one_ outer join produced matches? (Have I lost you all by now?) To make a long story short, I changed the datatype back to Long, but I'm still puzzled.
    thx
    Pat

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Conversion from Long to Double (Access XP SP2)

    We would need to know (much) more about the data to be able to comment.

Posting Permissions

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