Expression calculation

[MICHELE]

This is what I want a field on my report to do:
If a field in my query is "U" then I want a "?" to show up, if not then I want to sum what's in another field.
I'm getting an error message that my expression is too complex because it uses numbers and variables. How can I solve this, it's driving me nuts!
Thank you

 

[jwindon]

What data type is your field "U"? It appears that your field is text in which case, yes, access is going to balk. Any chance this field could/should hold a zero value versus a "?" ?

 

[MICHELE]

It could show a value of 0 in my table, but it needs to show up as a "?" on my report.