Hi,

I have on my database a field set up as "Country" where all new
entries in the database have their country location recorded.

How can I count how many entries in the database are from US, UK,
Italy etc etc

Many thanks

Djuro

p.s. I am using FM6 on a Mac

You can create a new field and set the value to 1.

Then create a summary field that counts or totals the new field.

Create a report that has a group header that groups and sorts by the country
and add the new summary field to the grouping. You dont need to put any
fields in the body because you don't need individual records...just a total.
Remember, you will only see the total if you sort by country then view the
layout in preview mode.

Good luck.
Paul



"Djuro" <djurornic (AT) yahoo (DOT) co.uk> wrote

Paul,

Thanks for the idea, but, is there anyway that can be done in normal
browse mode without having to create reports?

Regards


Djuro

"Paul" <pzspam (AT) rogers (DOT) com> wrote

Sorry Djuro, I'm don't if it can be done in browse mode. Maybe someone else
in the group can be of assistance.


"Djuro" <djurornic (AT) yahoo (DOT) co.uk> wrote

Djuro wrote:

Yes. Make the field = 1 as Paul suggested. Then make a relation from
that table to itself based on the Country name. Make a calc field =
Sum(FieldEquallingOne). (the field you just created.

Place that field on your browse layout and it will show how many for
whatever country is set in that record.

Thanks Kevin, good to know. I tried it out and it works great.

"Kevin Hayes" <me (AT) here (DOT) com> wrote

Hi Paul,

Glad to hear you got it working.

FWIW though, once again there is no reason to add the extra field that
equals 1.

Just build the calc so that
= Count(Relationship::CountryName)

Since CountryName must include data that satisfies the relationship,
you can count on it (double entendre intentional).

Good luck!


On 2004-10-14 10:43:23 -0400, "Paul" <pzspam (AT) rogers (DOT) com> said:

Perfect, thanks again.

"flamel" <nospam (AT) nospam (DOT) net> wrote

Very good point on the Count. I'm used to making that "1" field, because
I used to make one in every table for doing Cartesian joins (pre-version 7)