Counting in Found Set...newbie

[rwc.sheehan]

Possible? How?

-or is it possible to count based on a field meeting a specific criteria (containing a specific value, not just any value)?

[Steve T.]

Howdy! I'm not sure I follow exactly but you may want to look at these and see if these will help solve your problem...

Status (CurrentFoundCount)

-- this gives you the number of records in your found set

summary fields... (count of field x)

-- this gives you the number of records in the found set for which field x has values

PatternCount

-- this counts the number of occurances of a string in a body of text

--ST

[rwc.sheehan]

but what if i want to find how many currently found records have a value of "y" for "field x"...sorry for the poor explanation

[Steve T.]

Hmm...

I have not use it before, but the GetSummary function may work for you in this situation.

GetSummary Help has as an example...

GetSummary(Total Sales, Country) returns a summary of all records pertaining to the value in the Country field.

Either that, or you can create a calc field y_specific that only has value if y=specific and then use a summary field that counts y_specific instead, I suppose... kinda weak if there's several but it should be okay if it's just that 1 criterion. I'm sure there's better ways of doing this... probably having to do w/relationships and self-joins and what not which are still kind of fuzzy to me.

Ah, well... not really my area of expertise, but I hope this helps.

--ST

[rwc.sheehan]

thanks. ya, i'm not entirely familiar with relationships and summaries, so i've started doing it the long way with calculations and totals. thanks for the help