Query Criteria Questions

[zgray]

I have a query with 6 fields in it that are being calculated right there in the query. The results of the calculations are either "Done" or "Not Done." I want to make it so that if all 6 say "Done" it falls off the query. If just one of the 6 say "Not Done" it has to stay on.

I cant seem to figure it out. I feel like there is a simple solution to make this happen that im just not seeing.

 

[SmallTomato]

I am not expert but can't you just make the criteria: where Field 1 = "Not Done" or Field 2 = "Not Done" or Field 3 = "Not Done" etc. Then only ones with at least one Not Done will show.

 

[zgray]

I am not expert but can't you just make the criteria: where Field 1 = "Not Done" or Field 2 = "Not Done" or Field 3 = "Not Done" etc. Then only ones with at least one Not Done will show.

If I put them all on the or line in the query it only showed the ones where all 6 are "Not Done." I went into the SQL of it and changed all the and's to or's and it worked.

I just thought putting it on the or line in the query design did that for me. Then after I changed the SQL to that, back in design view and it put the "Not Done" on the criteria line for the first field, second field on the or line, the third field one blow that and so on. So its nice to visualize what it did.

Learn something new everyday thanks!

 

[SmallTomato]

When using the Designer, you have to put each criteria for the or line one line down.

Woops, saw you stated that . Nevermind but glad I could help.