I need to query my access table to determine which review each employee needs completed. We have 6 fields
Empreview1start
Empreview1finish
Empreview2start
Empreview2finish
Empreview3start
Empreview3finish
What I am after is a query that will show this:
If empreview1start is not null and empreview1finish is null then show Review 1
If empreview2start is not null and empreview2finish is null then show Review 2
If empreview3start is not null and empteview3finish is null then show review 3
What would my access query be to achieve this?
Empreview1start
Empreview1finish
Empreview2start
Empreview2finish
Empreview3start
Empreview3finish
What I am after is a query that will show this:
If empreview1start is not null and empreview1finish is null then show Review 1
If empreview2start is not null and empreview2finish is null then show Review 2
If empreview3start is not null and empteview3finish is null then show review 3
What would my access query be to achieve this?