I can't quite make this work, but have to confess I'd never spotted 'GetNthRecord' - I was scouring the 'get' functions for this and it turns out to be logical??
So now I have something like: GetNthRecord ( Product_First_Letter ; Get ( RecordNumber )-1 ) and I can definitely use this to build in the character where it's needed. Thanks very much! on 22.05.2008 15:30, Don Wieland at [EMAIL PROTECTED] wrote: > On May 22, 2008, at 2:33 AM, Emma Glaisher wrote: > >> Now, I want the Balloons calculation to say Aha, the first letter >> of Balloons is not the same as the first letter of Apples (the >> previous record). I will need a heading to announce that there is a >> new letter, so I shall also add into my calculation field: >> >> <Heading>B<end Heading>return >> <B>Balloons<B> 27 >> >> And I can¹t see how to do it! > > One way is to establish a calculation that will append the HEADER to > the first record of the Letter_Group: > > Let say your TABLE is called "Products" and your fields are: > > Product - (Text Result) > Qty - (Number Result) > > Define a new field called: > > Product_First_Letter - (Calculation, Text Result) = Left(Products, 1) > > Define a new SELF-JOIN relationship (Product Table to Product Table) > called "First_Letter_Group": > > Products::Product_First_Letter = Products::Product_First_Letter > Options - No creation/deletion of related records > Sort - Product (Ascending) > > Define a new field: > > Product_TAG - (Calculation, Text Result) = > If(Product = GetNthRecord ( First_Letter_Group::Product ; 1 ); > "<Heading>" & Upper ( Left ( Product ; 1 ) ) & "<end Heading>¶<B>" & > Product & "<B> " & Qty; "<B>" & Product & "<B> " & Qty) > > Make sure this field is UNSTORED (Storage Options....) > > Use the Product_TAG field to generate the results you need. > > Hope this helps! > > Don Wieland > D W D a t a C o n c e p t s > ~~~~~~~~~~~~~~~~~~~~~~~~~ > [EMAIL PROTECTED] > Direct Line - (714) 389-4026 > > Integrated data solutions to fit your business needs. > > - - > Inbound email: This email has been scanned for viruses by MessageLabs > (Fourninety) - - Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law.
