dbTalk Databases Forums  

Sumary fields FM 10 Pro adv

comp.databases.filemaker comp.databases.filemaker


Discuss Sumary fields FM 10 Pro adv in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Hatzigiannakis Nikos
 
Posts: n/a

Default Sumary fields FM 10 Pro adv - 02-22-2010 , 04:19 AM






I have a problem doing the following:



I have a file with student records: Student name, Class, and Grade



I have classes A,B, C and D



I wand four calculated fields to display maximum grade of class A, maximum
grade of class B, maximum grade of class C, and maximum grade of class D.



Any help will be much appreciated!

Reply With Quote
  #2  
Old   
Shaw NewsGroup
 
Posts: n/a

Default Re: Sumary fields FM 10 Pro adv - 02-22-2010 , 11:41 AM






"Hatzigiannakis Nikos" <nikos (AT) ypai (DOT) gr> wrote

Quote:
I have a problem doing the following:



I have a file with student records: Student name, Class, and Grade



I have classes A,B, C and D



I wand four calculated fields to display maximum grade of class A, maximum
grade of class B, maximum grade of class C, and maximum grade of class D.



Any help will be much appreciated!


1. Sort the records by Class then Student Name. Force new page on Class
field

2. Make a sub-summary section on layout (select place below) sorted by Class

3. Create a summary field called sMax_Grade

4. Place summary field in the sub-summary section of layout. Format value to
required dec. lace number.

Al Lawrance
www.lddsis.ca

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.