What is wrong with this statement and how do I fix it. in SQL View
[code][IIf([transaction_activity].[type]="No",[transaction_activity].[Description],transaction_activity].[type])][code]
Basically what I am saying if in the [Type] field there is the word "NO" Then look in the [Description] field and bring over that value, and everything else in the [Type] field stays the same. I am changing only the "NO" to what ever the first 30 characters states in the [Description] field. I need it not to go over 30 characters