Not display information if criteria is not met

  • Thread starter Thread starter Andi
  • Start date Start date
A

Andi

I have an Employee review table that I need to query. The table is set so
each employee can have up to 10 reviews by 10 different reviewers. Reviews
will be complete (=1), pending (=2) or incomplete (=3). I only want to view
the complete reviews for each employee.

For example if Review1 and Review 5 are complete, I only want to see
Reviewer1 and Reviewer5 displayed in my query.

I tried limiting based on RevComplete1 to RevComplete10 =1 but it only
returned the records of Employees with all Reviews Complete. I then tried
limiting based on RevComplete1 or RevComplete2 ...... = 1 but the Name of all
reviewers for each employee display even though some of them are still
pending or incomplete.

Is there any way I can do this?
 
Andi -

It sounds like you have one record containing all 10 possible reviews.
Instead you should have a separate record for each review/reviewer.

That said, you can do something like this in your query for each reviewer:
Reviewer_1: Iif([RevComplete1] = 1,[Reviewer1],"")

This will 'hide' the reviewer's name if the review is not complete.
 
Thanks. This worked for me.

Daryl S said:
Andi -

It sounds like you have one record containing all 10 possible reviews.
Instead you should have a separate record for each review/reviewer.

That said, you can do something like this in your query for each reviewer:
Reviewer_1: Iif([RevComplete1] = 1,[Reviewer1],"")

This will 'hide' the reviewer's name if the review is not complete.

--
Daryl S


Andi said:
I have an Employee review table that I need to query. The table is set so
each employee can have up to 10 reviews by 10 different reviewers. Reviews
will be complete (=1), pending (=2) or incomplete (=3). I only want to view
the complete reviews for each employee.

For example if Review1 and Review 5 are complete, I only want to see
Reviewer1 and Reviewer5 displayed in my query.

I tried limiting based on RevComplete1 to RevComplete10 =1 but it only
returned the records of Employees with all Reviews Complete. I then tried
limiting based on RevComplete1 or RevComplete2 ...... = 1 but the Name of all
reviewers for each employee display even though some of them are still
pending or incomplete.

Is there any way I can do this?
Click to expand...
Click to expand...
 
Back
Top