@

Hello!

I have a fairly simple database that is being asked a complicated question. First it is looking at the number of entries in a portal and wanting to know how many entries there are. And how many records have the same number of entries. Got that done beautifully subsummaries are my friend!

Now what I am needing it to day with each of those groups, for it to summarize the number of portals that have the same entries. For example in my group of records that have 3 entries in each portal, I need to be able to say how many of those portals have entries xyz and how many of those portals that have entries abc.

Any thoughts or am I chasing a dream?

Thanks!

!

So, you need a calculated field, that counts the number of parent records, that contain "something" in their child portal?

Not chasing a dream, but two fields are required in your parent table.

EG create an unstored calculation field called "ChildPatternCount" with a calculation of:

Basically you check a list of the child values for those patterns, and if they exist, return the number "1" as a result.

Then you can create a summary type field in the parent table that is just a sum of the "ChildPatternCount" field. That would give you the total count of any records that contain the patterns you searched for in the portals.

That can be adapted and copied across as many different pattern fields you need to create. This is a basic form. There are other ways using more complicated queries (like ExecuteSQL() ), but they may be over your head at a basic level.