Using mutiple criteria for the same row (1 Viewer)

Ravi Kumar

Registered User.
Local time
Today, 15:41
Joined
Aug 22, 2019
Messages
162
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.
 

Attachments

  • Untitled.png
    Untitled.png
    25.7 KB · Views: 79

Users who are viewing this thread

Top Bottom