dgambale@gmail.com
Registered User.
- Local time
- Yesterday, 21:35
- Joined
- Jul 31, 2013
- Messages
- 19
Hello,
Im trying to develop certain criteria in a query and having some issue adding operators to the IFF statement.
In the criteria section of the query builder I have the following:
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "#2 Or #0","*")
I have also tried less complex as I thought the hashtag was messing things up
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "PA Or Ca","*")
This does not work either, however if I just have one term in true side of the expression it works fine.
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "PA","*")
Is there a way to develop the true side so I could have essentially a criteria with many OR values. Like PA or CA or NY....
Thanks for your help
Im trying to develop certain criteria in a query and having some issue adding operators to the IFF statement.
In the criteria section of the query builder I have the following:
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "#2 Or #0","*")
I have also tried less complex as I thought the hashtag was messing things up
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "PA Or Ca","*")
This does not work either, however if I just have one term in true side of the expression it works fine.
IIf([Forms]![Vendor Query]![cmbMinSize]="#2", "PA","*")
Is there a way to develop the true side so I could have essentially a criteria with many OR values. Like PA or CA or NY....
Thanks for your help