crosstab if then

[Guest]

I have a field in a crosstab query designated in design view as follows:
Account Name:AccountName where AccountName is a field in one of the tables
used in the query.

There is another field inthe query which contains an If then statement based
off of the aformentioned Account Name field as follows: Account Name #2:
IIf(([Account Name]="..."),"....",....")

When I run the query it asks for a parameter input for [Account Name]. I
have declared this parameter. Why is this happening?

 

[Guest]

Please post the SQL view of your query. I always avoid using a derived column
in a calculation for another column.