Sorry if this one has been answered but I had no clue how to even search... I have a querry that I would like to reference a form to gather the criteria... (EASY - I can do that with No Problems) but what I have is 1 FIELD in my database which has only 5 options that can be entered by the user. Here they are.
1.Prelim 2.Cold 3.Warm 4.Hot 5.Dead
Now on a search form I am attempting to create seperate check boxes where the user can check on the box and search... easy for just one of the following criteria being searched out but if I want them to lets say be able to check on HOT and COLD, I am not sure how to get an AND statement in there. I know i can use an IIF() but the problem resides with lets say they check DEAD too, and so on.... I am hoping someone can help or give me some ideas.
Thank you - Arlan
1.Prelim 2.Cold 3.Warm 4.Hot 5.Dead
Now on a search form I am attempting to create seperate check boxes where the user can check on the box and search... easy for just one of the following criteria being searched out but if I want them to lets say be able to check on HOT and COLD, I am not sure how to get an AND statement in there. I know i can use an IIF() but the problem resides with lets say they check DEAD too, and so on.... I am hoping someone can help or give me some ideas.
Thank you - Arlan
