Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Type mismatch in join expression error (97)

    Type mismatch in join expression error
    I get a

  2. #2
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Adelaide, South Australia, Australia
    Posts
    146
    Thanks
    5
    Thanked 5 Times in 5 Posts

    Re: Type mismatch in join expression error (97)

    Without knowing more about the underlying data fields, I could be way off track here - especially as I don't read SQL that well from scratch, and don't have time to set up a sample database to play with; but you said that Query4.tempYear contains an empty string, against which you're trying to do a left join from NewQuery.tempYear. I would expect a year to be a number at some point - are you trying to join a number field to the empty string field?

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Type mismatch in join expression error (97)

    I believe Alison is quite right.
    Pat

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Type mismatch in join expression error (97)

    Yes, something like that Allison.

Posting Permissions

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