query criteria based on 2 cell values in diffrent rows

G

Guest

I'm running a query which contains 5 columns 2 of these colums [Detail
Status] and [Header Status] can contain diffrent values. if the combination
matches it should not show the entire row. for example: [detail status] =
"installation ok" and [header status] = "waiting for report" then the row
should be left out.

can you please help me? i

another example:
[col1]="installation ok" and [col2] is "failed" then SHOW ROW
[col1]="failed" and [col2]= "waiting for report" then SHOW ROW
[col1]="install ok" and [col2] ="waiting for report" then DO NOT SHOW ROW
 
M

MGFoster

Badvibez said:
I'm running a query which contains 5 columns 2 of these colums [Detail
Status] and [Header Status] can contain diffrent values. if the combination
matches it should not show the entire row. for example: [detail status] =
"installation ok" and [header status] = "waiting for report" then the row
should be left out.

can you please help me? i

another example:
[col1]="installation ok" and [col2] is "failed" then SHOW ROW
[col1]="failed" and [col2]= "waiting for report" then SHOW ROW
[col1]="install ok" and [col2] ="waiting for report" then DO NOT SHOW ROW
Click to expand...

WHERE [col1] <> "install ok"
AND [col2] <> "waiting for report"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging Fields in a query 1
Crosstab Query with only 2 columns 1
Help with Query 4
duplicate rows returned in query with inner join and where clause 3
Changing Data Type of Column in Query. 1
Match based on a lookup and then flag 4
MS Access Function that Returns a Sequence Number in a Query 2
Transform and concatenation of column data 2

Top