Do select on FORCED and if it returns 0 record, run your regular select.
>
>I have the following requirement: if the Queue Name is FORCED and its expiration date greater than my start date, my form should display accounts in this queue first. If there is no FORCED queue, but there is default queue before and including my start date, the form will show those records. Otherwise the form should display nothing and the user would be able to specify criteria.
>
>Originally my program was written without taking FORCED queue in consideration. Today I'd like to add FORCED queue requirement, but I am not sure how to achive my goal, e.g. if there are FORCED queue record I need to display them and only them, and if there are no FORCED queue, I need to display primary gueue.
>
>Here is my code for the filter criteria with today's modification, but it's obviously not what I really want.
>
<snip>
--sb--