Ray Pearson presented the following explanation :
I do not see anything obviously wrong with the Sql you have listed, but
we cannot see what columns are in the tables FarNorth and Sub2.
FarNotrh.Status is a Text type
Sub2.Year is a number
Sub2AmountPaid does not have a Default Value and
FarNorth.Email is also a text type.
I'd reccomend you taking the Sql and Paste it into the Sql view of a
new query, and see if Access gives you a hint as to where the problem