TooManyReports
Registered User.
- Local time
- Today, 09:36
- Joined
- Aug 13, 2010
- Messages
- 43
I am using the follow IIF statement and get zero results back - IIf([Forms]![Basic Form]![Pricing Region]="*",True,[Forms]![Basic Form]![Pricing Region]). If I change the True to 15, I get the information from Region 15 to come back, the result I need is all numbers to come back. I have tried >0 and get 0 results and between 0 and 999 and still get 0 results. Any suggestions??