I am constructing an ad-hoc query form that has a Status field displayed as a dropdown box. The dropdown is populated dynamically to have each possible status as an option (there are 6 possibles). I have added a static option of (%) to cover any Status, and everything works fine so far. <BR><BR>Now I need to create a static option that represents 5 of the six options (Show me all statuses except "Closed"). I know the answer should involve using the IN statement in SQL, but I can't seem to get the multiple values to work.<BR><BR>Any help will be greatly appreciated.