![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
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. |
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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. |
#5
| |||
| |||
|
|
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. |
#6
| |||
| |||
|
|
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 |
![]() |
| Thread Tools | |
| Display Modes | |
| |