Count occurences

[jtscott]

I want a function which will count how often a particular field value occurs in a range of records, where the number 2 will be held in one single digit field (e.g. how many records are there where the "Rating" field is set to 2).

I want to display this in a layout based on another table via a portal.

Thanks.

[The Shadow]

Make a relationship between the two 2 fields you have, and create a summary field in the same table as the Rating field that is set to Count(Rating).

When you place that related summary field in your portal, it will count the number of matches for the portal row it is in.