Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Summary Field in Form

0 views
Skip to first unread message

GBH333

unread,
Mar 7, 2001, 8:24:25 AM3/7/01
to
I have a Summary field in my FORM that relates to a field in the table that I
would like to perform a Summary Calculation on. All I want to do is define the
field to do a Summary COUNT.

I would like to COUNT ALL records that show the text "SSI" in the field, but no
matter what I put in the Calculated Field dialog box, the Summary Count counts
ALL the records...no matter what is in the dialog box. Below is the default
dialog that I am trying to alter...

Count([:WORK:Publishing Administration.CAT])

Description of above
WORK = Directory
Publishing Administration = Table Name
CAT = Field
SSI = The text that I want to do a count on

I believe COUNT ALL is what I want to do (rather than COUNT), but no matter
where I put the information of what I want to count (in this case all records
that show the letters "SSI" in the field) the Summary comes back counting ALL
records in the table.

Any thoughts? Thank you

Byron

0 new messages