By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 921 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

IIF Statement Problem

P: 1
I have created an invoice report and am using the following IIF expression for sales tax: =IIf([TaxStatusID]=1, [ctlSubtotal]*.075,0)

Whenever I switch to Report View, it keeps prompting me to Enter Parameter Value for TaxStatusID.

I used the expression =IIf([TaxStatusID]=1, "Taxable", "Exempt") in a query report before and it worked fine.

How do I fix this?
Mar 21 '12 #1
Share this Question
Share on Google+
1 Reply

P: 759
Check again the field name and/or the control name for TaxStatusID or even if this control exist in your report.
Mar 22 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.