Type mismatch in join expression error (97)

[arage]

Type mismatch in join expression error
I get a

[alifrog]

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?

[patt]

I believe Alison is quite right.
Pat

[arage]

Yes, something like that Allison.