Using mutiple criteria for the same row

[Ravi Kumar]

dear all ,
I have a query with 3 columns: Instrument name , status , & model no .
status column has 4 different values , in-use, spare , sent for repair & withdrawn.
But I need my query table to show only in-use & spare instruments .
When I am using "OR" in criteria , the instruments are listing in two different rows .
That is one one row - in-use & spare in another row .but I need to see them in a same row .
can anyone help me fixing this issue .
I have attached images for your reference.

 

[June7]

Review http://allenbrowne.com/func-concat.html