Still 9 I'm afraid, and keeping job is the main priority here, never mind upgrades!
But your Approved_Page field is exactly what I wanted, and I can't think why I couldn't see it - I think I just wanted to get straight to a total, but this is a totally invisible field, so causes no extra problems. Thank you very much! On 7/11/11 22:48, "Steve Cassidy" <[email protected]> wrote: > If you are using FMP11, you can display subsummary parts in browse mode. Might > that solve the problem? > > > On the other hand, if you do want to use the Sum function, you need to know > that it acts on a set of related records. In your shoes, I'd have a table > Publications with a child table Sections, related by publication_id. In > Sections, I'd add a field Approved_Pages, with a calculation something like > Case(not isEmpty(Date Approved), Total Pages in Section, 0). Then in the > Publications table, add a calculated field using the Sum function, summing > Approved_Pages. Place this field on a layout, and for each record in > Publications you'll see the corresponding number of approved pages for that > publication. > <BR> @|from|cn|@ @|from|title|@ - @|from|company|@ Tel: @|from|telephonenumber|@ @|from|wwwhomepage|@ @|from|streetaddress|@, @|from|l|@, @|from|st|@, @|from|postalcode|@, @|from|co|@ ----------------------------------------------------------------------------------------------------------------------------------------- Media Square plc or any of its subsidiary companies may not be held responsible for the content of this email as it may reflect the personal view of the sender and not that of the company. Should you receive this email in error, please notify the sender immediately and do not disclose, copy or distribute it. While Media Square plc scans all outbound emails for viruses, it cannot be held responsible for any infected files that you may receive. Media Square plc advises all recipients to virus scan any file attachments. Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered Office: Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ This email message has been scanned and delivered safely by Mimecast. -----------------------------------------------------------------------------------------------------------------------------------------
