Error in query

[PJ]

I have the following expression in my query and I'm getting this error "The
text is to long to be edited". Is there a different way to write this?

Capital Markets Name: IIf([Capital Markets
originator]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets originator]) & IIf([Capital Markets
Derivatives]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Derivatives]) & IIf([Capital Markets
Distributor]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Distributor]) & IIf([Capital Markets Jr
Support]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Jr Support]) & IIf([Capital Markets
Referral]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Referral]) & IIf([Capital Markets Backstop
Originator]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Backstop Originator]) & IIf([Capital Markets Backstop
Trader]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital
Markets Backstop Trader]) & IIf([Capital Markets Referral
Secondary]]=[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName],[Capital Markets Referral Secondary])

Thanks in advance
PJ

 

[Jerry Whittle]

Also if you are running this in the frmReportCriteriaMarketer form, you could
simplify things like
[forms]![frmReportCriteriaMarketer]![txtEntertheMarketerName] like so:
Me![txtEntertheMarketerName]

Renaming your frmReportCriteriaMarketer to something like frmRCM would save
a lot of text. Same goes for then names of controls on the form.