Hi, I need some help, please! I have table “tbl_CodeObjets” with fields “ObjectType” and “CodeObjectID”.
I have another table “tbl_Objects” with fields “NameObject” and “CodeObjectID”.
And I have “tbl_Inspections” with fields “TypeOfCheck” and “ObjectID.
So, I want to sum and calculate this: For each ObjectType how many different checks there are. Here is the Database and the picture:
I have another table “tbl_Objects” with fields “NameObject” and “CodeObjectID”.
And I have “tbl_Inspections” with fields “TypeOfCheck” and “ObjectID.
So, I want to sum and calculate this: For each ObjectType how many different checks there are. Here is the Database and the picture: