Thanks for your reply.
However the If statement is not the issue as it is working fine. It is the concatenation which is working not as expected.
('Season ' & (Year(`TxDate`)-1) & '-' & (Year(`TxDate`))
is resulting in 0.
I am sure that Year works fine as I tried it as a separate expression. I am afraid that & is being interpreted as a logical AND expression.
Btw - I am using MySQL but this is not the issue.