query to check first for a criteria, if not, next criteria

[megatronixs]

Hi all,
I have a query that will add a case to some one that can do the quality check on some one else data.
there are 8 fields in the query.
There is the field "sent_for_check_first_time_date" with criteria "Is Not Null"
second ond that needs criteria is "final_checker_name" this one has to be "Is Null"
Now I have been asked to apoint in the query to 2 person all cases that have in the field "unit_case" "CTB"
If there is no "CTB" available, they should be able to get the other type of cases too.

Is there any way to first check for "CTB" and if not, then the others?

Greetings.

 

[Galaxiom]

I don't have a clear understanding of your question but I suspect you should have a different structure where unit_case, CTB and maybe others are in the same field with another field to indicate the difference.

 

[megatronixs]

Hi Galaxiom,

I actually solved by adding a new query with the extra CTB in it.
This is now run from a second button to call up the query.
It works great, maybe not an elegant solution, but still great.

Greetings.