IIF Statement with Enter Parameters

[talkiechick]

So I have a query I have created that has terms and a balance connected to each row of data. I wanted to know the total for each category, therefore I created and aggregate function and named it balance. Then I needed to limit all balances lower than 1,000,000 and have them combined into one category. So i created this IIF Statement -

Expr1: IIf([Balance]>=1000000,[Description],"Other-Combined")

Now the IIF statement works fine in the query, but a Enter parameter box appears when I run it. I enter in one, and the outcome is fine. However, when I create a report off the query it also pops up the enter parameter, there is also has me enter values for many other fields my query never asked for. Also by just hitting 1 each time, my report looks askew and the numbers are not showing. Also my balance amounts for each category show up blank in the report.

Can someone help explain to me what i am doing wrong?

 

[Datagopher]

Is Description an actual field in your query?

Dan
Access Development

So I have a query I have created that has terms and a balance connected to each row of data. I wanted to know the total for each category, therefore I created and aggregate function and named it balance. Then I needed to limit all balances lower than 1,000,000 and have them combined into one category. So i created this IIF Statement -

Expr1: IIf([Balance]>=1000000,[Description],"Other-Combined")

Now the IIF statement works fine in the query, but a Enter parameter box appears when I run it. I enter in one, and the outcome is fine. However, when I create a report off the query it also pops up the enter parameter, there is also has me enter values for many other fields my query never asked for. Also by just hitting 1 each time, my report looks askew and the numbers are not showing. Also my balance amounts for each category show up blank in the report.

Can someone help explain to me what i am doing wrong?

 

[talkiechick]

Yes [Description] is an actual field in the query it actually comes from one of my tables.

 

[Datagopher]

Check your query and make sure that you don't have any fields referenced where theres not an actual field in your record source. That's usually what causes that problem.

Dan
Access Development

Yes [Description] is an actual field in the query it actually comes from one of my tables.

 

[talkiechick]

Thanks Dan, I figured it out. I didn't have the IIF statement set up as an expression, it had grouped by in the Total category. That fixed the issue.