dbTalk Databases Forums  

Count Function Inconsistent

comp.databases.filemaker comp.databases.filemaker


Discuss Count Function Inconsistent in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
computer.1on1@gmail.com
 
Posts: n/a

Default Count Function Inconsistent - 05-26-2007 , 02:11 PM






With a list of records to have a tally of how many records show up in
the layout I put in the Header <<CountFieldname>> and sometimes the
number of records shows up when I look at the list and sometimes when
I create a new layout it will just show "<<CountFieldname>>" and not a
number.

I pick a field to put after Count that shows up in every record. Why
does it work in some layouts and not in others? What am I forgetting
to do?

I'm confused.

Thanks for your help.


Reply With Quote
  #2  
Old   
Matt WIlls
 
Posts: n/a

Default Re: Count Function Inconsistent - 05-26-2007 , 02:39 PM






In article
<1180206669.440192.190870 (AT) a26g2000pre (DOT) googlegroups.com>computer.1on1@gm
ail.com wrote:

Quote:
With a list of records to have a tally of how many records show up
in the layout I put in the Header <<CountFieldname>> and sometimes
the number of records shows up when I look at the list and sometimes
when I create a new layout it will just show "<<CountFieldname>>" and
not
anumber.

I pick a field to put after Count that shows up in every record.
Why does it work in some layouts and not in others? What am I
forgettingto do?

I'm confused.

In Merge Field, the field goes inside the angle brackets, the text
with which the value is merged goes outside the brackets.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo



Reply With Quote
  #3  
Old   
computer.1on1@gmail.com
 
Posts: n/a

Default Re: Count Function Inconsistent - 05-26-2007 , 03:03 PM



On May 26, 12:39 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:
Quote:
In article
1180206669.440192.190... (AT) a26g2000pre (DOT) googlegroups.com>computer.1on1@gm

ail.com wrote:
With a list of records to have a tally of how many records show up
in the layout I put in the Header <<CountFieldname>> and sometimes
the number of records shows up when I look at the list and sometimes
when I create a new layout it will just show "<<CountFieldname>>" and
not
anumber.

I pick a field to put after Count that shows up in every record.
Why does it work in some layouts and not in others? What am I
forgettingto do?

I'm confused.

In Merge Field, the field goes inside the angle brackets, the text
with which the value is merged goes outside the brackets.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it athttp://www.malcom-mac.com/nemo
Didn't understand your answer. In a layout from a race listing the
participants, to have a number of participants show up in the header
do you type in
<<CountLast>> Participants (Last being the last name field in the
layout)
or is there a better command to type in or a different way to have
this occur?

It has worked in many older layouts I've done in different databases.
It won't work in this layout I'm working on now. Does it make a
different that the layout is drawing from two different tables? I'm
working in FileMaker Pro 7.

thanks for your help.



Reply With Quote
  #4  
Old   
Howard Schlossberg
 
Posts: n/a

Default Re: Count Function Inconsistent - 05-26-2007 , 03:29 PM



You cannot resolve a calculation by typing it in a layout. Create an
unstored calc field. If you just want a count of records in the found
set, then use Get(FoundCount) as the definition for your calc field. If
you name the field "FoundCount", then insert the merge text field onto
your layout, which will result in "<<FoundCount>>".

An alternative is to create a summary field that is defined as the count
of some field that always has a value (your primary ID field, for
example). Place that summary field on your layout (either as a field or
as merge text). You can even use this summary field to display in
related table layouts.



computer.1on1 (AT) gmail (DOT) com wrote:
Quote:
On May 26, 12:39 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:
In article
1180206669.440192.190... (AT) a26g2000pre (DOT) googlegroups.com>computer.1on1@gm

ail.com wrote:
With a list of records to have a tally of how many records show up
in the layout I put in the Header <<CountFieldname>> and sometimes
the number of records shows up when I look at the list and sometimes
when I create a new layout it will just show "<<CountFieldname>>" and
not
anumber.
I pick a field to put after Count that shows up in every record.
Why does it work in some layouts and not in others? What am I
forgettingto do?
I'm confused.
In Merge Field, the field goes inside the angle brackets, the text
with which the value is merged goes outside the brackets.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it athttp://www.malcom-mac.com/nemo

Didn't understand your answer. In a layout from a race listing the
participants, to have a number of participants show up in the header
do you type in
CountLast>> Participants (Last being the last name field in the
layout)
or is there a better command to type in or a different way to have
this occur?

It has worked in many older layouts I've done in different databases.
It won't work in this layout I'm working on now. Does it make a
different that the layout is drawing from two different tables? I'm
working in FileMaker Pro 7.

thanks for your help.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance


Reply With Quote
  #5  
Old   
Matt WIlls
 
Posts: n/a

Default Re: Count Function Inconsistent - 05-26-2007 , 03:33 PM



In article
<1180209833.424788.171850 (AT) z28g2000prd (DOT) googlegroups.com>computer.1on1@gm
ail.com wrote:

Quote:
On May 26, 12:39 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:
In article


1180206669.440192.190... (AT) a26g2000pre (DOT) googlegroups.com>computer.1on1@
gm
ail.com wrote:
With a list of records to have a tally of how many records show
up > in the layout I put in the Header <<CountFieldname>> and
sometimes > the number of records shows up when I look at the list
and sometimes > when I create a new layout it will just show
"<<CountFieldname>>" and > not
anumber.

I pick a field to put after Count that shows up in every
record. > Why does it work in some layouts and not in others? What
am I
forgettingto do?

I'm confused.

In Merge Field, the field goes inside the angle brackets, the text
with which the value is merged goes outside the brackets.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it athttp://www.malcom-mac.com/nemo

Didn't understand your answer. In a layout from a race listing the
participants, to have a number of participants show up in the
headerdo you type in
CountLast>> Participants (Last being the last name field in the
layout)
or is there a better command to type in or a different way to
havethis occur?

It has worked in many older layouts I've done in different
databases. It won't work in this layout I'm working on now. Does it
make a different that the layout is drawing from two different
tables? I'mworking in FileMaker Pro 7.

The construction I saw in your message was <<CountFieldname>>. If that
doesn't show properly in your newsreader (it didn't in mine, until I
went to reply), that's two left angle brackets CountFieldname two
right angle brackets.
That's the Merge Field syntax, such as would be used to create a
merged letter for printing, inserting field values in a paragraph, for
instance.
If you want just the field on your layout, just place it as you would
any field, either by dragging it from the tools or using the menu
Insert Field.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it at http://www.malcom-mac.com/nemo



Reply With Quote
  #6  
Old   
computer.1on1@gmail.com
 
Posts: n/a

Default Re: Count Function Inconsistent - 05-26-2007 , 03:45 PM



When I create a field with the calculation Get(FoundCount) and name
that field "CountFoundRecords"

Then type in the header of the layout
<<CountFoundRecords>> Participants

I get the number of all the records in the database and not the number
of the found records.

BUT, when I create a summary field to count a field that shows in
every record THAT counts the found records. THANK YOU!

On May 26, 1:29 pm, Howard Schlossberg
<how... (AT) nospam (DOT) fmprosolutions.com> wrote:
Quote:
You cannot resolve a calculation by typing it in a layout. Create an
unstored calc field. If you just want acountof records in the found
set, then use Get(FoundCount) as the definition for your calc field. If
you name the field "FoundCount", then insert the merge text field onto
your layout, which will result in "<<FoundCount>>".

An alternative is to create a summary field that is defined as thecount
of some field that always has a value (your primary ID field, for
example). Place that summary field on your layout (either as a field or
as merge text). You can even use this summary field to display in
related table layouts.




computer.1... (AT) gmail (DOT) com wrote:
On May 26, 12:39 pm, Matt WIlls <I... (AT) Witz (DOT) End> wrote:
In article
1180206669.440192.190... (AT) a26g2000pre (DOT) googlegroups.com>computer.1on1@gm

ail.com wrote:
With a list of records to have a tally of how many records show up
in the layout I put in the Header <<CountFieldname>> and sometimes
the number of records shows up when I look at the list and sometimes
when I create a new layout it will just show "<<CountFieldname>>" and
not
anumber.
I pick a field to put afterCountthat shows up in every record.
Why does it work in some layouts and not in others? What am I
forgettingto do?
I'm confused.
In Merge Field, the field goes inside the angle brackets, the text
with which the value is merged goes outside the brackets.
Matt

--
I'm trying a new usenet client for Mac, Nemo OS X.
You can download it athttp://www.malcom-mac.com/nemo

Didn't understand your answer. In a layout from a race listing the
participants, to have a number of participants show up in the header
do you type in
CountLast>> Participants (Last being the last name field in the
layout)
or is there a better command to type in or a different way to have
this occur?

It has worked in many older layouts I've done in different databases.
It won't work in this layout I'm working on now. Does it make a
different that the layout is drawing from two different tables? I'm
working in FileMaker Pro 7.

thanks for your help.

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Member, FileMaker Business Alliance



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.