Not display information if criteria is not met

[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?

 

[Daryl S]

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.

 

[Andi]

Thanks. This worked for me.

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

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?