Expression in query prompts for input when it shouldn't 1

[swskipper]

I have a query using the IIF function and it prompts for input when it shouldn't. This query is built on another query becuase several tables need to be joined. The correct data is displayed, but why does the expression prompt?

Here is the expression:
TotTX: IIf([TTot]+[SumOfExtra Credit Points]>400,400,[TTot]+[SumOfExtra Credit Points])

TotTX is NOT a column in a table.

 

[Golom]

It prompts because [TTot] is not a column in a table. SQL assumes that, if an expression in a query is not a field then it must be a user-supplied parameter and that generates a prompt. It will also prompt for [SumOfExtra Credit Points] if that isn't a field.

BTW: You state that TotTX is not a column but your statement contains [TTot]. I assume that you meant [TTot] and not ToTX.