Hi Sean

The child account does not have a link code. It only has the child code.

so if I use this query for the whole dataset by just filtering on child code, it gives me the count of all the child codes instead of count of child codes belonging ot a particular account.

I need to write a query which somehow ties the child accounts to their parent account using the common account no.

Does that make sense?