Hi all,
Not sure how to handle this one
I have a table with approximately 1000 records
I would like to write some of the information into a new table as a summary for a quick view of outstanding transactions
If a registration has any of the 6 fields as incomplete, I want to update the table with just a no
If all the records in that field for the same registration has been completed, a yes to be saved in the new table
Will I have to create a query for each control I need to check or will i be able to do this utilizing one query?
Deferred will have a different criteria, if all are not deferred, I need a yes indication for completed
Sample
Not sure how to handle this one
I have a table with approximately 1000 records
I would like to write some of the information into a new table as a summary for a quick view of outstanding transactions
If a registration has any of the 6 fields as incomplete, I want to update the table with just a no
If all the records in that field for the same registration has been completed, a yes to be saved in the new table
Will I have to create a query for each control I need to check or will i be able to do this utilizing one query?
Deferred will have a different criteria, if all are not deferred, I need a yes indication for completed
Sample
Registration | Sequence | Approved | CS Raised | Rectified | Deferred |
XYZ | 1 | Yes | Yes | Yes | No |
XYZ | 2 | Yes | Yes | Yes | No |
XYZ | 3 | Yes | Yes | Yes | No |
XYZ | 4 | Yes | Yes | No | No |
XYZ | 5 | Yes | Yes | Yes | No |
XYZ | 6 | Yes | Yes | Yes | No |
XYZ | 7 | Yes | Yes | No | No |
XYZ | 8 | Yes | Yes | Yes | No |
Result | |||||
Registration | Approved | CS Raised | Rectified | Deferred | |
XYZ | Yes | Yes | No | Yes |