Hi everyone,
I think this is query focused but I'm not sure this is the only solution so I thought I would post it here. Here is what I am trying to accomplish:
I have two tables: tblMain and tblSectionReview
There is a many to one relationship between the two tables as there are many reviews for each record entry in tblMain. What I need to do in a query (I think) is to test which records are entered on the many side of the relationship.
For example: All records in tblMain with have a total of 6 related records in tblReview as tblSectionReview holds the approval sign offs for the supervisor reviews. What I need to do in a query is return all records in tblMain that are at a certain stage in the sign off process so, for example, If I'm looking to create a report of all records in tblMain that need the fourth supervisor sign off I would need to filter the records where Supervisor3 has signed off and approved BUT supervisor4 has not signed off(made a record entry in tblSectionReview)...
Should I use a nested IIF Statement in the query (never have used before) or is there some other means by which to get the desired results?
Thanks in advance for all help,
Kevin
I think this is query focused but I'm not sure this is the only solution so I thought I would post it here. Here is what I am trying to accomplish:
I have two tables: tblMain and tblSectionReview
There is a many to one relationship between the two tables as there are many reviews for each record entry in tblMain. What I need to do in a query (I think) is to test which records are entered on the many side of the relationship.
For example: All records in tblMain with have a total of 6 related records in tblReview as tblSectionReview holds the approval sign offs for the supervisor reviews. What I need to do in a query is return all records in tblMain that are at a certain stage in the sign off process so, for example, If I'm looking to create a report of all records in tblMain that need the fourth supervisor sign off I would need to filter the records where Supervisor3 has signed off and approved BUT supervisor4 has not signed off(made a record entry in tblSectionReview)...
Should I use a nested IIF Statement in the query (never have used before) or is there some other means by which to get the desired results?
Thanks in advance for all help,
Kevin