Equine Investor
Board Regular
- Joined
- Nov 20, 2002
- Messages
- 103
I have a table with SEX of horses denoted as g (for gelding), c (for colt), f (for filly) etc etc.
I have a combo box linked to a query and this is what I have as my query syntax.
Like IIf([Forms]![SEARCH]![Combo410]="","*",IIf([Forms]![SEARCH]![Combo410]="Colts","c",IIf([Forms]![SEARCH]![Combo410]="Fillies","f",IIf([Forms]![SEARCH]![Combo410]="Geldings","g",IIf([Forms]![SEARCH]![Combo410]="Horses","h",IIf([Forms]![SEARCH]![Combo410]="Mares","m"))))))
This all works fine BUT I would like to add other criteria to the drop down list suchs as "Fillies and Mares" and "Colts, Geldings and Horses" so that the query would include BOTH or ALL these values.
Could someone please suggest a solution so that if "Colts, Geldings and Horses" were selected, then the combo box query would search for "c", "g" AND "h".
I'm at my wits end!
I have a combo box linked to a query and this is what I have as my query syntax.
Like IIf([Forms]![SEARCH]![Combo410]="","*",IIf([Forms]![SEARCH]![Combo410]="Colts","c",IIf([Forms]![SEARCH]![Combo410]="Fillies","f",IIf([Forms]![SEARCH]![Combo410]="Geldings","g",IIf([Forms]![SEARCH]![Combo410]="Horses","h",IIf([Forms]![SEARCH]![Combo410]="Mares","m"))))))
This all works fine BUT I would like to add other criteria to the drop down list suchs as "Fillies and Mares" and "Colts, Geldings and Horses" so that the query would include BOTH or ALL these values.
Could someone please suggest a solution so that if "Colts, Geldings and Horses" were selected, then the combo box query would search for "c", "g" AND "h".
I'm at my wits end!