AnsweredAssumed Answered

How to display/print the lowest and highest value only of a field range in a found set.

Question asked by jenh on Feb 24, 2010
Latest reply on Mar 1, 2010 by jenh

Title

How to display/print the lowest and highest value only of a field range in a found set.

Post

I have FileMaker Pro 10X on Windows Vista.  

 

I get a successful found set on a find. 

 

There is a sub summary set on a date.  Works great,  gathers all the records I need by date. 

  

Within each date there are numerous sequential records. 

I only want to get the first and last record of the sequential records within the sub summary date. 

There is a field within the found data that is sequentially numbered however the numbers of the field are always different ie: 1 -150, 533-622, or 212-230. 

I just want to capture (Display/Print) the first and last numbered fields only within that sub summary range, ie: Record 1 and 150 or Record 533 and 622.  

 

 

Sample of solution would be  

 

01/01/2010

 

File #  9  

File # 15

 

as opposed to

 

01/01/2010

 

File # 9

File # 10

File # 11

File # 12  

File # 14

File # 15

 

 

 

Any suggestions or references would be appreciated.   TY  

 

 

Outcomes